Viewing 2 posts - 1 through 2 (of 2 total)
In my case I used DROP_EXISTING to convert 2nd (primary key index) from nonclustered into clustered. So the whole sequence was:
1. Delete all foreign key references (ALTER TABLE Table1 DROP...
October 10, 2011 at 3:43 am
#1392305
I recently had this problem on SQL Server 2005 SP2 and SP3, and in my case the reason was that there were two identical indexes on a table:
-1st was...
October 10, 2011 at 3:27 am
#1392299