Renaming/Removing extended system extended stored procedures - TechRepublic
Question
September 25, 2007 at 01:34 AM
girgazzim

Renaming/Removing extended system extended stored procedures

by girgazzim . Updated 18 years, 10 months ago

Hi.

Can someone please point me in the right direction for rendering a list of system extended stored procedures? I’ve tried using sp_rename, drop procedure, sp_dropextendedstoredproc and dbcc dropextendedstoredproc. All to no avail.

I’ve tried creating a user that is a memeber of the sysadmin and securityadmin sever roles, and made the default schema ‘sys’. Still no luck.

I’m running sql 2005 std sp 2.

Any ideas where I’m going wrong?

Thanks.

This discussion is locked

All Comments