On Tuesday, May 29, 2012 4:13:40 PM UTC-6, Bob Barrows wrote:
> tbone wrote:
> > I have a need to remove sp_makewebtask in sql server 2005. I am
> > logging in with a user that is in the sysadmin role however when I try
> > to run the command: drop procedure sp_makewebtask
> > I receive:
> > Msg 3701, Level 11, State 5, Line 1
> > Cannot drop the procedure 'sp_makewebtask', because it does not exist
> > or you do not have permission.
> > The same thing happens for xp_makewebtask. Is it possible to drop
> > these procedures? If so how do I do it?
>
> You might be in the wrong database. What database are you using when you run
> this command?

I have tried master and msdb as well as a user db.