Drop Procs
public sql v1 · immutabledeclare @build nvarchar(1024), @name nvarchar(128)declare tmpCur cursor fast_forward read_only for ( select name from dbo.sysobjects where xtype = N'P' and status>0 and name like 'up_CLR%' -- mod here.... ) open tmpCurfetch next from tmpCur into @namewhile @@fetch_status = 0begin -- Exec this... print 'drop proc ' + @name fetch next from tmpCur into @nameendclose tmpCurdeallocate tmpCur