modify system stored procedures?
-
is there a way to hook on system stored procedures or replace it, i want to hook or replace sp_who2, is there a way?, im using sql server 2000
This is NOT recommended since other users might rely on the system stored procedure for correct functionality. However, you can replace them by going into the master database, dropping the procedure and then recreating it.
-
This is NOT recommended since other users might rely on the system stored procedure for correct functionality. However, you can replace them by going into the master database, dropping the procedure and then recreating it.
thanks let me try it "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox [^]
-
This is NOT recommended since other users might rely on the system stored procedure for correct functionality. However, you can replace them by going into the master database, dropping the procedure and then recreating it.
but i cant drop it i get an error :( "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox [^]
-
but i cant drop it i get an error :( "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox [^]
What's the error?
-
but i cant drop it i get an error :( "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox [^]
ok sorry.. forgot to tell you.. you need to perform the following steps first to enable changing of system stored procedures:
execute sp_configure 'allow updates',1 go reconfigure with override goOnce you are done, set allow updates to 0:execute sp_configure 'allow updates',0 go reconfigure with override goYou do know that this is highly unsupported and not recommended.. :) -
ok sorry.. forgot to tell you.. you need to perform the following steps first to enable changing of system stored procedures:
execute sp_configure 'allow updates',1 go reconfigure with override goOnce you are done, set allow updates to 0:execute sp_configure 'allow updates',0 go reconfigure with override goYou do know that this is highly unsupported and not recommended.. :)still doesn`t work i dont know why, any other idea?, thanx for the help :). "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox [^]
-
still doesn`t work i dont know why, any other idea?, thanx for the help :). "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox [^]
Please tell me what error you are getting.
-
Please tell me what error you are getting.
i get a messagebox telling me that i cant erease system objects, im trying to delete sp_who from master database. "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox [^]
-
i get a messagebox telling me that i cant erease system objects, im trying to delete sp_who from master database. "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox [^]
You need to perform the entire query with T-SQL as follows:
use master go execute sp_configure 'allow updates',1 go reconfigure with override go drop procedure sp_who go execute sp_configure 'allow updates',0 go reconfigure with override go -
You need to perform the entire query with T-SQL as follows:
use master go execute sp_configure 'allow updates',1 go reconfigure with override go drop procedure sp_who go execute sp_configure 'allow updates',0 go reconfigure with override gothanks that worked :-D, thanks for your help. "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox [^]