martyuni
asked on
sp_dropextendedproc sp_replwritetovarbin not working
I am trying to drop the sp_replwritetovarbin from an instance of sql server 2005. I run
Using master
execute sp_dropextendedproc 'sp_replwritetovarbin'
I get the error:
Cannot find the object 'sp_replwritetovarbin', because it does not exist or you do not have permission.
The object does exist, and I have used both the sa account and a AD admin account. Any ideas?
Using master
execute sp_dropextendedproc 'sp_replwritetovarbin'
I get the error:
Cannot find the object 'sp_replwritetovarbin', because it does not exist or you do not have permission.
The object does exist, and I have used both the sa account and a AD admin account. Any ideas?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Not sure.
ASKER
Would have liked to removed it using the sp_dropextendedproc, but this will work.
Here is the security advisory in which they describe the various reasons for getting different messages and provide a script to disable it on all instances.
http://support.microsoft.com/kb/961040
http://support.microsoft.com/kb/961040
ASKER