September 29, 2011 at 10:00 am
Script: DROP INDEX PK_compile_tblCredentials ON dbo.compile_tblCredentials
Error: Could not proceed with index DDL operation on table 'compile_tblCredentials' because it conflicts with another concurrent operation that is already in progress on the object. The concurrent operation could be an online index operation on the same object or another concurrent operation that moves index pages like DBCC SHRINKFILE.
Scenario: Mirrored SQL 2k8. Autoshrink is DISABLED/FALSE
This error comes immediately after running. I have seen very little as to the cause. In our testing sandbox (idential db's) I can rebuild it without issue. In Production (where the issue lies), I cannot even drop the index. It throws the same error.
Any help will be appreciated.
September 29, 2011 at 11:33 am
Something else is accessing the index at the same time, and it can't just wait for it to finish.
Dropping a clustered index in a production database is usually something you'd do after setting the database to Single User mode to lock out any other connections.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 29, 2011 at 12:40 pm
I was only testing to see if I could drop it b/c I was getting the same error while trying to REBUILD it. So, no matter what action I take against this index I receive the same error:
My REBUILD script: ALTER INDEX PK_compile_tblCredentials ON dbo.compile_tblCredentials REBUILD WITH (FILLFACTOR = 100, PAD_INDEX = ON,ONLINE = ON);
I posted on that issue previously and found no correct answers:
http://qa.sqlservercentral.com/Forums/Topic1182071-1550-1.aspx?Update=1
September 29, 2011 at 12:46 pm
Are you using Enterprise Edition?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 29, 2011 at 12:52 pm
Yes, Enterprise Edition x64
Version: 10.0.2746
September 30, 2011 at 7:25 am
What isolation level are you using for your connections? Have you enabled read-only snapshot isolation?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 3, 2011 at 9:52 am
In our script the ISOLATION LEVEL is READ UNCOMMITED but from our testing it doesn't matter the isolation level. Same error every time...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply