insert the name of all store procedures

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 2005 Forums

Transact-SQL (2005)

insert the name of all store procedures

Author

Topic

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2009-07-09 : 17:13:50

There are about 100 store procedures in my db.
How to code to insert the name of all store procedures into a table?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-09 : 17:16:25

Use the INFORMATION_SCHEMA views.

N 56°04'39.26"
E 12°55'05.63"

saran_d28
Starting Member

36 Posts

Posted - 2009-07-10 : 06:15:24

insert into mytable
select object_name from sysobjects where xtype = 'P'

--Saravanan

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-07-10 : 06:24:08

quote:
Originally posted by saran_d28

insert into mytable
select object_name(id) from sysobjects where xtype = 'P'

--Saravanan

also see http://msdn.microsoft.com/en-us/library/ms177596.aspx
sysobjects will be removed in future version. Avoid using that

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources