Hi,

I want to delete all stored procedures in a Database. Can anyone give me the query to do this?

__________________
The OXYGEN
Delivers edgy, intelligent Technology to all...

Hi,

This is the simple way to do this.

Use Database name

declare @procName varchar(500)

declare cur cursor

for Select [name] from sys.procedures where [type] = 'P' and is_ms_shipped = 0 and [name] not like 'sp[_]%diagram%'

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
deallocate cur

__________________
S.Balasubramanian
Nothing is impossible