Post reply

Cannot run sp_AddLogin in Transaction

  • October 30, 2001 at 5:33 pm

    #77423

    I want to setup a db structure for creating and manipulating user accounts when a record is inserted/updated in the users table. Using a trigger oin the table I get the above message (which is understandable!).

    Anyone have a work-around for this?

  • October 30, 2001 at 5:57 pm

    #419525

    You can put the request into a table and have a scheduled task that updates the system tables.

    You won't get on-line error/success info - but maybe you should ask whether this is the sort of thing that should be executed automatically anyway - what happens if something goes wrong and you want to restore master.

    If you had integrated security you could just add them to the nt group - I guess you could do that via xp_cmdshell.


    Cursors never.
    DTS - only when needed and never to control.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply