How to delete a sqlserver system stored procedure in master?

Hi,
I need to replace a sqlserver system stored procedure
(sp_depends) because of a bug in the master database. But
it doesn't allow me to delete it. What steps do I need
to follow to delete a system stored procedure?
Thx"Tony" <indengr@.yahoo.com> wrote in message
news:087901c38391$a55abe30$a101280a@.phx.gbl...
> I need to replace a sqlserver system stored procedure
> (sp_depends) because of a bug in the master database. But
> it doesn't allow me to delete it. What steps do I need
> to follow to delete a system stored procedure?
Which bug, can you document that for us? Providing you are a sysadmin you
should be able to use ALTER PROC to modify a system stored procedure. As I'm
sure you're aware, making revisions like this place you in unsupported
territory,
Steve|||here is the bug:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;180490
I'm getting this error in the sqlserver log. So I had to
replace the sp_depends procedure. I can't rename or
delete the procedure. I administer the database.
>--Original Message--
>"Tony" <indengr@.yahoo.com> wrote in message
>news:087901c38391$a55abe30$a101280a@.phx.gbl...
>> I need to replace a sqlserver system stored procedure
>> (sp_depends) because of a bug in the master database.
But
>> it doesn't allow me to delete it. What steps do I need
>> to follow to delete a system stored procedure?
>Which bug, can you document that for us? Providing you
are a sysadmin you
>should be able to use ALTER PROC to modify a system
stored procedure. As I'm
>sure you're aware, making revisions like this place you
in unsupported
>territory,
>Steve
>
>.
>|||The article you refer recommends doing just that -- creating a NEW procedure
called sp_depends2 and using that instead of sp_depends. It does not say to
delete sp_depends.
The Enterprise Manager has an extra layer of security that does not allow
you to drop any objects marked as system objects.
What error are you getting in the log?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"tony" <indengr@.yahoo.com> wrote in message
news:099f01c383a5$7a5c7cf0$a301280a@.phx.gbl...
> here is the bug:
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;180490
> I'm getting this error in the sqlserver log. So I had to
> replace the sp_depends procedure. I can't rename or
> delete the procedure. I administer the database.
>
>
> >--Original Message--
> >"Tony" <indengr@.yahoo.com> wrote in message
> >news:087901c38391$a55abe30$a101280a@.phx.gbl...
> >> I need to replace a sqlserver system stored procedure
> >> (sp_depends) because of a bug in the master database.
> But
> >> it doesn't allow me to delete it. What steps do I need
> >> to follow to delete a system stored procedure?
> >
> >Which bug, can you document that for us? Providing you
> are a sysadmin you
> >should be able to use ALTER PROC to modify a system
> stored procedure. As I'm
> >sure you're aware, making revisions like this place you
> in unsupported
> >territory,
> >
> >Steve
> >
> >
> >
> >.
> >|||I don't think whatever you are trying to do is worth the effort.
Both sp_depends and sp_depends2 rely on the sysdepends table, which is for
all practical purposes not dependable (particularly for stored procedures).
Thee is no supported utility to verify whether sysdepends table is good and
there is no supported utility to correct whatever inconsistencies or add
missing information.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"tony" <indengr@.yahoo.com> wrote in message
news:099f01c383a5$7a5c7cf0$a301280a@.phx.gbl...
> here is the bug:
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;180490
> I'm getting this error in the sqlserver log. So I had to
> replace the sp_depends procedure. I can't rename or
> delete the procedure. I administer the database.
>
>
> >--Original Message--
> >"Tony" <indengr@.yahoo.com> wrote in message
> >news:087901c38391$a55abe30$a101280a@.phx.gbl...
> >> I need to replace a sqlserver system stored procedure
> >> (sp_depends) because of a bug in the master database.
> But
> >> it doesn't allow me to delete it. What steps do I need
> >> to follow to delete a system stored procedure?
> >
> >Which bug, can you document that for us? Providing you
> are a sysadmin you
> >should be able to use ALTER PROC to modify a system
> stored procedure. As I'm
> >sure you're aware, making revisions like this place you
> in unsupported
> >territory,
> >
> >Steve
> >
> >
> >
> >.
> >|||You should be write your own stored procedure
>--Original Message--
>Hi,
> I need to replace a sqlserver system stored procedure
>(sp_depends) because of a bug in the master database.
But
>it doesn't allow me to delete it. What steps do I need
>to follow to delete a system stored procedure?
>Thx
>.
>