Sql server

Db Cleaner

/* Drop all non-system stored procs */DECLARE @name VARCHAR(128)DECLARE @SQL VARCHAR(254) SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘P’ AND category = 0 ORDER BY [name]) WHILE @name is not nullBEGIN    SELECT @SQL = ‘DROP PROCEDURE [dbo].[‘ + RTRIM(@name) +’]’    EXEC (@SQL)    PRINT ‘Dropped Procedure: ‘ + @name    SELECT @nameContinue Reading “Db Cleaner”