Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sassaidi
Starting Member
7 Posts |
 Posted - 2002-07-17 : 09:24:14
|
| Hi,I really need to edit a system stored procedure which is being called when a user logs in SQL.How can I add some code in that system stored procedure?Thanks for your help,Sas |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-17 : 09:34:53
|
| DO NOT EDIT SYSTEM PROCEDURES EVER!You risk serious system problems by editing a procedure, because it could have unknown side effects. Moreover, if you do FUBAR something and call MS, better not let them find out you did edit the procedure. It's not worth the risk.Which procedure are you talking about? Why do you need to edit it? What about copying its code, modifying it, and creating your own version of it under another name? |
 |
|
|
sassaidi
Starting Member
7 Posts |
Posted - 2002-07-17 : 09:56:42
|
Thanks for your reply.The system SP is sp_MSdbUserAccess. I don't know exactly when it is called but I would like to do some stuff right after it was called or at the end of the stored procedure! It happens during the login of the user.Thanks again for your help,Sasquote:
DO NOT EDIT SYSTEM PROCEDURES EVER!You risk serious system problems by editing a procedure, because it could have unknown side effects. Moreover, if you do FUBAR something and call MS, better not let them find out you did edit the procedure. It's not worth the risk.Which procedure are you talking about? Why do you need to edit it? What about copying its code, modifying it, and creating your own version of it under another name?
|
|
|
|
|
|
|
|
|
Can I edit a system stored procedure?