Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add a column in master.sysusers
Message
 
 
To
16/05/2003 11:23:12
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00789262
Message ID:
00789303
Views:
19
I would stronly adwise not to do that. You may take a look at allow updates Option in BOL.

>Hi everyones,
>
>I want to add a column in master.sysusers In query analyser, I used this syntax:
>
>alter table sysusers add suid as smallint
>
>and I got this error:
>
>Server: Msg 1706, Level 16, State 4, Line 1
>System table 'sysusers' was not created, because ad hoc updates to system catalogs are not enabled.
>
>What can I do?
>
>It's a one shot deal, I want to do it only once. I need this because I run an old application design for SQL7 on a SQL2000 and in SQL7, the column suid existed. I don't care about the value itself, I can fill it in manually once it's created.
>
>TIA,
>Diane Robitaille eng.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform