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?
Printable View
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.