Can't delete sp_makewebtask

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?

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?

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.

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.

tbone (tony.despain@gmail.com) writes:
> 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?

Why do you need to do this? They are system procedures, and you can't drop
them.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Wednesday, May 30, 2012 1:21:07 AM UTC-6, Erland Sommarskog wrote:
> tbone (tony.despain@gmail.com) writes:
> > 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?
>
> Why do you need to do this? They are system procedures, and you can't drop
> them.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx

If I can't get rid of them how does one disable them? I have removed execute permissions for the public role, is that what you mean by disable?

tbone wrote:
> On Wednesday, May 30, 2012 1:21:07 AM UTC-6, Erland Sommarskog wrote:
>> tbone (tony.despain@gmail.com) writes:
>>> 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?
>>
>> Why do you need to do this? They are system procedures, and you
>> can't drop them.
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>>
>> Books Online for SQL Server 2005 at
>>
http://www.microsoft.com/technet/pro...ads/books.mspx
>> Books Online for SQL Server 2000 at
>> http://www.microsoft.com/sql/prodinf...ons/books.mspx
>
> If I can't get rid of them how does one disable them? I have removed
> execute permissions for the public role, is that what you mean by
> disable?
Wow, no access to Books Online or Google? Here you go. From:
http://www.kodyaz.com/articles/enabl...kewebtask.aspx

sp_configure 'Web Assistant Procedures', 0;
Reconfigure;

Ok that was already done, thanks for the info, I think I'll just have to tell our audit script programmer that 2005 doesn't allow that to be dropped whereas it did in 2000.