Home Forums SQL Server 2005 T-SQL (SS2K5) Is it safe to use "update syscolumns set colstat" RE: Is it safe to use "update syscolumns set colstat"

  • I don't believe you can update the system tables in SQL Server 2005. I wouldn't do it even if you can.

    The usual suggestion for this type of issue is to do a select into new_table and then drop the old table and do an sp_rename on the new table.