Deleting Obsolete Stored Procedures in SQL

[Former Member]

Hi,

I want to delete all the stored procedures in my servers.

while searching for this i got the NOTE- 333458.

Actually i am not aware how to use this sql scripts.

From that note i am able to calculate how many stored procedures are there in my the database and deleting all the stored procedures by using sap_droproc stored procedure.

since i am not aware much about the SQL scripts, i am not able to use the following stored procedures.

1) sap_drop_obsolete_procs

2) sap_drop_unused_procs

3) sap_drop_subroutine_pool_procs

Two text file are available with the note number 33458. SQL script and some information is there in that text file. Could you tell me how to create and run the above procedures?

Regards,

Gayathry.

[Former Member · Accepted solution]

SQL server 2000 : use Query analyser

SQL 2005 : Use Management studio for SQL Server 2005

[Former Member · Accepted solution]

Hi Wojciech Matulewicz,

Thank you for your reply,

I know where we can run this.

I want to know more about this storage procedures, like how freequently we can run and the imprecations after running this, whats the steps involved to perform this like creating the storage procedure and executing the storage procedure etc..

All the above things are there in the note 333458.But, since i am doing first time, i want to know your suggestions

Thanks&Regards,

Gayathry.

[Former Member]

After updating the Kernel patch, from 221 to 247 there is no red signal in EWA report regarding Storedprocedures.