Orblin McLoon
SSC Veteran
Points: 276
More actions
August 21, 2005 at 7:11 pm
#165728
What table are stored procedures stored in?
(not extended stored procedures)
Ninja's_RGR'us
SSC Guru
Points: 294069
August 21, 2005 at 9:47 pm
#583796
Is this what you want??
Select id, name, crdate from dbo.SysObjects where XType = 'P' order by name
Chris Hedgate
One Orange Chip
Points: 25041
August 22, 2005 at 1:05 am
#583816
And if it is the text of a procedure you are looking for you should take a look at syscomments. Or, better yet, use the system stored procedure sp_helptext to get the text.
--Chris Hedgate http://www.hedgate.net/Contributor to the Best of SQL Server Central volumesArticles: http://www.sqlservercentral.com/columnists/chedgate/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply