Posts Tagged ‘Stored Procedures’

Drop All Stored Procedures From Your Database SQL 2008

This code sample demonstrate how to drop all stored procedures from your Database. declare @procName varchar(500) declare cur cursor for select [name] from sys.objects where type = ‘p’ open cur fetch next from cur into @procName while @@fetch_status = 0 begin exec(‘drop procedure ‘ + @procName) fetch next from cur into @procName end close cur […]

More »