Networks

Ask something
Question Locked

ad hoc updates in SQL 2005

0 helpful
3 replies

by ross1664

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In SQL 2000 we used to be able to switch on ad hoc updates to system catalogues in server properties. I use this quite often to update user SID's in sysusers when we restore customer databases to our servers. How is this done in SQL 2005 as there appears to be no flag in server properties to allow direct updates to system catalogues

3 replies

by Member 22070467

This should allow you to update the system catalog...although I don't really recommend doing it.

sp_configure 'allow updates','1'
reconfigure with override

by reiloid

SQL Server 2005 does not allow direct updates to the system catalogues.

This discussion is closed to new replies.