Djabarov, Robert
Robert.Djabarov at usaa.com
Wed Feb 26 14:04:01 CST 2003
Script the CREATE INDEX ... and drop it prior to ALTERing the table, then - run CREATE INDEX. ______________________________________________________ Robert Djabarov Certified MS SQL Server DBA Certified MS SQL Server Programmer Certified MS VB Programmer ? (210) 913-3148 - phone ( (210) 753-3148 - pager -----Original Message----- From: Stoker, Kenneth E [mailto:Kenneth.Stoker at pnl.gov] Sent: Wednesday, February 26, 2003 2:01 PM To: dba-SQLServer (E-mail) Subject: [dba-SQLServer]Temporarily Unbinding an Index Everyone, Can I temporarily unbind an index from a column, modify the column and bind the index back again? I have a database I am working on and I just want to change the column to Allow Nulls through T-SQL, but it won't let me because it says that the column is being used elsewhere, in an index. TIA Ken Stoker Technology Commercialization Information Systems Administrator PH: (509) 375-3758 FAX: (509) 375-6731 E-mail: Kenneth.Stoker at pnl.gov _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com