Miscellany

declare @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 N'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