Delete Stored Procedure via SQL

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

ive fixed it. the code was written wrong, made a concinuous loop it was ment to be.

          'delete all stored procedures

          strSQL = "Declare @prc varchar(150) "

strSQL = strSQL & "While (Select Count(*) from sysobjects where
name Like '" & strSPPrefix & "%' and xtype = 'P') > 0 "

          strSQL = strSQL & "Begin "

strSQL = strSQL & "Set @prc = (Select MIN([name]) from sysobjects
where name LIKE '" & strSPPrefix & "%' and xtype='P') "

          strSQL = strSQL & "Set @prc = 'Drop Procedure ' + @prc "

          strSQL = strSQL & " Exec(@prc) "

          strSQL = strSQL & "END "

or set the bold to TOP 1,

before it was making a field called name with the value 1, in a loop.

thanx anyway, also let you know.

Edited by dj air - 06 January 2005 at 1:30pm