query to delete stored proc created by user

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

query to delete stored proc created by user

Author

Topic

kirannatt
Yak Posting Veteran

66 Posts

Posted - 2006-09-22 : 14:26:43

I need query to delete all the stored proc created by user. The one I came up is : select * from sysobjects where xtype='p'

Plz let me know if I need to consider any other factor.

Thanks!

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-09-22 : 15:11:29

one way is to exec this code and then paste the output into a new window and run it:

select 'drop proc ' + routine_name from information_schema.routines where ROUTINE_SCHEMA = 'kirannatt'

Be One with the Optimizer
TG