Site Sections
Posts
120
Comments
117
Trackbacks
22
<< SQL: OPENXML and case sensitivity | Home | havarti and tuna >>
last modified date for stored procedure

I can't believe I just discovered the last_altered column in information_schema.routines in SQL Server 2005, all this time I thought there was no way to get the last modified date for a stored procedure.  Is there a catch?

Is Christmas really boring for the 7% of males who are red-green colorblind?

 

posted on Monday, June 11, 2007 11:42 AM Print
Comments
Gravatar
# re: last modified date for stored procedure
Matthew
9/27/2007 9:13 PM
Hey thanks for posting it, Google + this page helped me out!
Gravatar
# re: last modified date for stored procedure
M
1/7/2008 3:10 AM
select name, modify_date
from sys.procedures
Gravatar
# re: last modified date for stored procedure
AQ123
3/16/2008 11:03 AM
Thanks, solve our porblem
Gravatar
# re: last modified date for stored procedure
Mayank Parmar
9/7/2008 8:20 PM
Thanks, this worked for me.
Gravatar
# re: last modified date for stored procedure
jkar
1/21/2009 3:12 AM
Nice! Thanx mate...
Gravatar
# re: last modified date for stored procedure
Dinuke
4/27/2009 4:41 AM
Thanks for the post. Cheers.
Gravatar
# re: last modified date for stored procedure
Syed Muhammad Ahsan Arif
10/8/2009 6:48 PM
Thanks mate. nice work
Gravatar
# re: last modified date for stored procedure
Padmini
10/21/2009 6:59 PM
thanks a lot.. special thanks to M

Post Comment

Title *
Name *
Email
Url
Comment *  
 
Archives
Post Categories
News