last modified date for stored procedure

<< 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?

Print | posted on Monday, June 11, 2007 11:42 AM

Comments on this post

# re: last modified date for stored procedure

Hey thanks for posting it, Google + this page helped me out!

Left by Matthew on Sep 27, 2007 9:13 PM

# re: last modified date for stored procedure

select name, modify_date
from sys.procedures

Left by M on Jan 07, 2008 3:10 AM

# re: last modified date for stored procedure

Thanks, solve our porblem

Left by AQ123 on Mar 16, 2008 11:03 AM

# re: last modified date for stored procedure

Thanks, this worked for me.

Left by Mayank Parmar on Sep 07, 2008 8:20 PM

Your comment:

Title:

Name:

Email: (never displayed)

(will show your gravatar)

Website:

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Please add 4 and 3 and type the answer here:

The Wrecking Bawl