Path: csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From: "Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Can't delete sp_makewebtask
Date: Tue, 29 May 2012 18:13:40 -0400
Organization: A noiseless patient Spider
Lines: 15
Message-ID: <jq3hl8$qvd$1@dont-email.me>
References: <8b7e9ecc-5bed-46e0-8733-ec14c70c1cf8@googlegroups.com>
Injection-Date: Tue, 29 May 2012 22:12:56 +0000 (UTC)
Injection-Info: mx04.eternal-september.org; posting-host="vQmQhKLKuh0OvmkK+suVIw"; logging-data="27629"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19isEEpJeladxRq671exaqFML7s55MTWe0="
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646: Format=Flowed; Original
X-Antivirus-Status: Clean
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-Antivirus: avast! (VPS 120302-0, 03/02/2012), Outbound message
Cancel-Lock: sha1:yzDqJr9nAI2fl6KtdKNmFGlboN0=
X-Priority: 3
X-MSMail-Priority: Normal
Xref: csiph.com comp.databases.ms-sqlserver:1082

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?