September 16, 2010 at 5:05 am
As others have said, the question would have been better if the step dropping the constraint had been omitted.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 17, 2010 at 1:46 pm
Actually it is returned 3 rows and 2 cols..
with started negative value mainvalue
September 30, 2010 at 12:49 pm
Sorry if I am mistaken. I never tried this out but as per the MSDN article
http://msdn.microsoft.com/en-us/library/ms177456.aspx it says this
The data rows of the disabled clustered index cannot be accessed except to drop or rebuild the clustered index. This means the following:
These operations will fail: SELECT, UPDATE, DELETE, INSERT, CREATE INDEX, CREATE STATISTICS, UPDATE STATISTICS (on the index), and ALTER TABLE statements that modify table columns or constraints.
So in that case, wont the statement fail when we try to alter the table to drop the constraint??
September 30, 2010 at 2:01 pm
:laugh: Good catch, Ashwin. I think the documentation needs to be expanded to list dropping the constraint as an exception to this rule. Maybe you can submit this as a documentation bug?
June 14, 2011 at 2:52 pm
Interesting!!!
Viewing 5 posts - 31 through 34 (of 34 total)
You must be logged in to reply to this topic. Login to reply