Results 1 to 4 of 4

Thread: Editing sp_addlogin stored procedure

  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Question Editing sp_addlogin stored procedure

    I would like to add code to the sp_addlogin stored procedure in the master db, but it seems to be readonly. How can I get around that and be able to add code?

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    ofcourse you can modify, but why?
    why cant you create sp_addlogin2 instead.

    Companies like pentasafe/vigilent add their additional auditing codes in side system stored procedure.

  3. #3
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    do the following before you update...

    sp_configure "allow updates",1
    reconfigure with override


    then do alter procedure.

    Check your code and test it thoroughly before updating any system stored procedure

  4. #4
    Join Date
    Mar 2004
    Posts
    3
    Okay, I'm a newbie at working on these stored procedures. If I created a sp_newlogin2 procedure how could I make sure that it was called every time that sp_newlogin was called? Do I just have to check the dependencies of sp_newlogin to find that?

    Also, sorry for the cross-post. I posted it in the wrong category.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •