From: reb01501@NOSPAMyahoo.com   
      
   tbone wrote:   
   > 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.   
      
   I've just discovered they are located in the System.Resource database, which   
   is read-only so it appears you cannot delete them. What will be gained by   
   deleting them? You can disable them easily enough.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)