Drop All Procedures

by Behlul 28. November 2010 03:01

SELECT 'Drop Procedure ' + SCHEMA_NAME(schema_id)+'.'+name FROM sys.procedures

8bcae9c8-b711-4c78-9e03-0a80eb3b7e75|1|5.0

Tags:

Find Last updated stored proceduresSELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' order by modify_date descImprove Stored Procedure PerformanceSometimes even the simplest things can make a difference. One of these simple items that shoul...

Thank you