Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Disabling Indexes Expand / Collapse
Author
Message
Posted Thursday, September 16, 2010 5:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:59 AM
Points: 11,194, Visits: 11,166
As others have said, the question would have been better if the step dropping the constraint had been omitted.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #987104
Posted Friday, September 17, 2010 1:46 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 12, 2013 2:07 PM
Points: 168, Visits: 38
Actually it is returned 3 rows and 2 cols..
with started negative value mainvalue
Post #988538
Posted Thursday, September 30, 2010 12:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 5:57 AM
Points: 47, Visits: 90
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??
Post #996198
Posted Thursday, September 30, 2010 2:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:03 PM
Points: 6,002, Visits: 8,264
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?


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #996265
Posted Tuesday, June 14, 2011 2:52 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:09 AM
Points: 395, Visits: 168
Interesting!!!
Post #1125343
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse