Sorting Stored Procedures???

Question

Post reply

Sorting Stored Procedures???

Mike Menser

Hall of Fame

Points: 3679
More actions
January 15, 2010 at 8:44 am

#215634

Hello all! We have a development database we use to house all of our SP's. There are hundreds. I was wondering if there was anyway that I could view those SP's and sort them by creation date. Any ideas? Thanks!

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Select * from sys.objects WHERE type_desc = 'SQL_STORED_PROCEDURE' ORDER BY create_date

J-F Bergeron SSCrazy Eights Points: 8593 More actions · Answer 2

I think this does what you need:

SELECT name ,

SCHEMA_NAME(Schema_ID) ,

Create_Date ,

Modify_date ,

type_Desc

FROM sys.procedures

WHERE is_ms_shipped = 0 -- only those that were created by the user

ORDER BY Create_Date ASC

Cheers,

J-F

Mike Menser Hall of Fame Points: 3679 More actions · Answer 3

J-F Bergeron (1/15/2010)
I think this does what you need:
SELECT name ,
SCHEMA_NAME(Schema_ID) ,
Create_Date ,
Modify_date ,
type_Desc
FROM sys.procedures
WHERE is_ms_shipped = 0 -- only those that were created by the user
ORDER BY Create_Date ASC

Perfect, thanks!

J-F Bergeron SSCrazy Eights Points: 8593 More actions · Answer 4

J-F Bergeron

SSCrazy Eights

Points: 8593

January 15, 2010 at 9:07 am

#1104272

My pleasure,

Thanks for the feedback.

Cheers,

J-F

bgeige Say Hey Kid Points: 679 More actions · Answer 5

bgeige

Say Hey Kid

Points: 679

January 19, 2010 at 12:06 pm

#1105648

SSMS/View/Object Explorer Details/Procedures

LutzM SSC Guru Points: 107049 More actions · Answer 6

bgeige (1/19/2010)
SSMS/View/Object Explorer Details/Procedures

How would you sort the procs by creation date, as requested in the original post? :ermm:

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 7

lmu92 (1/19/2010)
bgeige (1/19/2010)
SSMS/View/Object Explorer Details/Procedures
How would you sort the procs by creation date, as requested in the original post? :ermm:

The columns shown are sortable. Just click on the column you want it to sort in the Object exploreer details tab.

-Roy

Mike Menser Hall of Fame Points: 3679 More actions · Answer 8

bgeige (1/19/2010)
SSMS/View/Object Explorer Details/Procedures

Since my post, I also discovered this method. Thanks for the follow-up though! Works great... object explorer details window has proven to be very helpful!

LutzM SSC Guru Points: 107049 More actions · Answer 9

Ooopss!! Sorry, my fault (I mixed Object Explorer and Object Explorer Details...):blush:

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]