June 13, 2011 at 2:11 am
Hi everyone
We are running SQL Server 2008 R2 ENT on out BI server - no hotfixes installed. I am getting an error in my maintanance plan for re-indexing:
"The unique index 'IndexName' on source table '[dbo].[TableName]' is used by Change Data Capture. To alter or drop the index, you must first disable Change Data Capture on the table."
This was an issue in SQL Server 2008 already and was fixed in SP2. Does anyone know anything about this issue coming up again in R2 release?
Thanks,
Theresa
June 13, 2011 at 5:46 am
R2 was released well prior to SQL 2008 SP2, so it's actually behind in terms of core RDBMS bug fixes. I suspect the bug will be in a cumulative update until SP1 is released (it's currently in CTP stage)
June 13, 2011 at 5:56 am
I'd recommend bugging MS on:
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=474589
The KB seems rather light on documentation for which version's/CU's it's fixed in
June 13, 2011 at 5:59 am
Thank you. That makes perfectly sense, didn't think about it like that 🙂
I will definately bug MS on it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply