Saturday, March 29, 2008
« CodeSmith NetTiers Best Practices | Main | T-SQL Drop Stored Procs - NetTiers versi... »
T-SQL Drop Stored Procs - query window

In Sql server query window, execute query that selects all stored procedures with the prefix you want (such as procedures that start with 'cust'):

SELECT 'DROP PROCEDURE ' + Name FROM sys.objects

WHERE type in (N'P', N'PC')

and name like 'cust_%'

 

Right-click the query window and set results to text. This gives you a results window with a single column of drop prodecures. Select all the text, copy to a new query window and execute.

Dina | SQL Server | T-SQL
Saturday, March 29, 2008 8:12:22 PM (Pacific Standard Time, UTC-08:00)  #    Disclaimer  |  Comments [0]  |  Related posts:
varchar(max) and varbinary(max) Questions and Answers
For Best Performance Avoid SELECT * Select Statements and never use COUNT(*)
Query SQL Server 2008 Total Memory Usage
How much Procedure Cache memory does one SQL Statement take up?
Indoubt Transaction in MSDTC
Mapping in SQL Server Reporting Services
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):
Live Comment Preview