Maqsood Ahmad (10/23/2008)

---

Through some how I want to change system catalog (syscolumns table)

In syscolumns table there is a column "colid" I want to change the value of this colid.

Maqsood Ahmad (10/23/2008)

---

Thanks for your prompt reply

I understand that in SQL Server 2005 we can't update it but because we have migrated our application from SQL Server 2000 to 2005 and in 2000 we were able to change these numbers. everthing was fine in 2000.

What i think that if we delete a column from any table SQL Server should update these number as well.

Now its hard to change whole application layer at this stage

Caution Updating fields in system tables can prevent an instance of Microsoft® SQL Server™ from running or can cause data loss. On production systems, you should not enable allow updates except under the direction of Microsoft Product Support Services. Because system tables are critical to the operation of SQL Server, enable allow updates only in tightly controlled situations.

Maqsood Ahmad (10/23/2008)

---

I executed this command
DBCC CHECKDB('AlarmSwitch') WITH NO_INFOMSGS
It took about 3 minutes and then I got message 'Command(s) completed successfully.'
Its mean there is no problem with my DB. Am I right?

You are right we should not rely on these values. In fact we should store this kind of info in our own tables but because this db access layer was desinged by an other team for us about five years ago (for SQL Server 200) and they used this approach.