CDC and reindexing error

Question

Post reply

CDC and reindexing error

ben.rosato

SSCommitted

Points: 1929
More actions
June 15, 2009 at 9:47 am

#132882

Anyone using CDC know how to reorganize the indexs? I get an error when I try
The unique index 'PK__Executio__05F5D74552AE4273' on source table '[dbo].[ExecutionLogStorage]' is used by Change Data Capture. To alter or drop the index, you must first disable Change Data Capture on the table.
Msg 3609, Level 16, State 2, Line 1

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

robinhc SSCommitted Points: 1617 More actions · Answer 1

Although it is deprecated, the DBCC DBREINDEX should work.

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=474589

Robin HC

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

What did you try to run that cause that error?

Alter Index Rebuild?

Alter Index Reorganise?

Drop index?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ben.rosato SSCommitted Points: 1929 More actions · Answer 3

You know, it's been so long I forgot what this was about. I got the error after setting up change data capture on a table. If I tried to rebuild the indexes, I would receive that error.

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 4

This was a bug in SQL 2008 that is fixed in CU6 for SP1 as per the following link:

http://support.microsoft.com/kb/977076/