September 27, 2005 at 10:47 am
I have a username, altiris, that was removed under "logins". I wanted to re-add the same username but it says it alreadys exitst. When I looked in sysxlogins, it is there. How do I update and/or delete from sysxlogins.
I tried the below and received the error.
delete sysxlogins
where name = 'altiris'
Error: Server: Msg 259, Level 16, State 2, Line 1
Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.
September 27, 2005 at 10:59 am
Under server properties enable "Allow modifications to be made directly to the system catalog"
September 27, 2005 at 11:14 am
Thank you so much, that worked perfectly.
September 27, 2005 at 11:23 am
Make sure you disallow the updates after this is done... you don't want to wipe out a systable by accident .
September 28, 2005 at 1:11 pm
The command is actually:
sp_configure 'allow updates',1 --> allow catalog updates
sp_configure 'allow updates',0 --> dis-allow catalog updates
There is also another 'nasty' side affect of this ... any stored procedure created when 'allow updates' is set to 1 will have the authority to update system tables directly !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 28, 2005 at 1:32 pm
Thanx for the warning... first time anyone mentions this here (AFAIK).
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply