Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spdhiva
Starting Member
13 Posts |
 Posted - 2006-10-13 : 15:42:17
|
| Could I updated the syscolumns table in SQL Server 2005?I would like to change the Default value of a bit column, which exists in 100 tables in the database. I try to update the syscoulmns table an dIt doesn't allow me.Could you help me? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-13 : 15:48:15
|
| Do NOT update the system tables just to change a default value!!! Use ALTER TABLE! Never, ever update the system tables. Always use the system stored procedures or commands that allow you to get the data updated. I haven't had to update system tables since SQL Server 7.0 or maybe even 6.5.Tara Kizer |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-13 : 16:56:56
|
| In fact it's such a bad idea to update the system tables that in SQL Server 2005 they are completely inaccessible, which is why you are not finding syscolumns. |
|
|
|
spdhiva
Starting Member
13 Posts |
Posted - 2006-10-16 : 09:24:54
|
| Thanks for your help. I have written a small scripts to update all the table columns. |
|
|
|
|
|
|
Updating the system Tables in SQL Server 2005