July 22, 2005 at 2:38 pm
Is there a easy way to printout all the stored procedures in a database? The previous DBA left the firm on short notice and I need to find out which stored procedures(903 total) are being used in production. Thanks in advance.
July 22, 2005 at 2:48 pm
do you mean the scripts of the stored procedures or just a list of all the procedures in the database - if it is the former, you can use enterprise manager to script them (either in individual files or a combined one) - if the latter, you can query the db using:
select * from sysobjects
where xtype = 'p'
order by name
**ASCII stupid question, get a stupid ANSI !!!**
July 22, 2005 at 2:58 pm
thanks. I also want to print to a file with just the name and crdate.
July 22, 2005 at 3:08 pm
greene - not sure if you're asking how to get the name etc..but if you are, then the query would be:
select name, crdate from sysobjects
where xtype = 'p'
order by crdate desc
this will give you most recently created to earliest created order!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy