Question

Locked

ad hoc updates in SQL 2005

By ross1664 ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums