Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Stanley Tan
Starting Member
25 Posts |
 Posted - 2003-09-12 : 20:08:25
|
| How can one drop all user defined stored procedures? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-12 : 22:16:53
|
| SELECT 'DROP PROCEDURE [' + name + ']' FROM sysobjects WHERE type='P' AND OBJECTPROPERTY(id, 'IsMSShipped')=0Run that in Query Analyzer, then copy and paste the results into another QA window and execute it. |
 |
|
|
|
|
|
Dropping All Stored Procedures