Geeks With Blogs

News
The Wrecking Bawl Destructuring query language, one keyword at a time.

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 all tech stuff , SQL Server | Back to top


Comments on this post: last modified date for stored procedure

# re: last modified date for stored procedure
Requesting Gravatar...
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
Requesting Gravatar...
select name, modify_date
from sys.procedures
Left by M on Jan 07, 2008 3:10 AM

# re: last modified date for stored procedure
Requesting Gravatar...
Thanks, solve our porblem
Left by AQ123 on Mar 16, 2008 11:03 AM

# re: last modified date for stored procedure
Requesting Gravatar...
Thanks, this worked for me.
Left by Mayank Parmar on Sep 07, 2008 8:20 PM

# re: last modified date for stored procedure
Requesting Gravatar...
Nice! Thanx mate...
Left by jkar on Jan 21, 2009 3:12 AM

# re: last modified date for stored procedure
Requesting Gravatar...
Thanks for the post. Cheers.
Left by Dinuke on Apr 27, 2009 4:41 AM

# re: last modified date for stored procedure
Requesting Gravatar...
Thanks mate. nice work
Left by Syed Muhammad Ahsan Arif on Oct 08, 2009 6:48 PM

# re: last modified date for stored procedure
Requesting Gravatar...
thanks a lot.. special thanks to M
Left by Padmini on Oct 21, 2009 6:59 PM

# re: last modified date for stored procedure
Requesting Gravatar...
You can also add "Date Last Modified" to the object explorer details view in SQL Management Studio 2008.
Left by jzapp on Apr 16, 2010 6:08 AM

# re: last modified date for stored procedure
Requesting Gravatar...
Is there a way to also get the actual login that did the modification?
Left by Marios Philippopoulos on Feb 22, 2011 5:09 AM

# re: last modified date for stored procedure
Requesting Gravatar...
thanks for posting - very useful.
Left by jp on May 31, 2011 12:00 AM

# re: last modified date for stored procedure
Requesting Gravatar...
Is there a way to also get the actual login that did the modification?
Left by Lor on Jun 29, 2011 5:28 PM

# re: last modified date for stored procedure
Requesting Gravatar...
select * from sys.objects
Left by vasya on Jun 30, 2011 12:12 AM

# re: last modified date for stored procedure
Requesting Gravatar...
@Lor: Not that I know of.
Left by Alex on Jun 30, 2011 6:08 AM

Your comment:
 (will show your gravatar)


Copyright © Alex Bransky | Powered by: GeeksWithBlogs.net