-
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?
-
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.
-
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
-
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
-
Forum Rules
|
|