to delete all the procedure in your specified database, just execute the following line. 1. select 'drop proc '+name from sys.objects where type='p' you will get list of procedure like drop table proc1 drop table proc2 select all and execute thats all

RAVIKUMAR S BANGALORE