sysxlogins help

  • 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.

  • Under server properties enable "Allow modifications to be made directly to the system catalog"

  • Thank you so much, that worked perfectly.

  • Make sure you disallow the updates after this is done... you don't want to wipe out a systable by accident .

  • 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."

  • 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