Geekswithblogs.net

The Wrecking Bawl

Destructuring query language, one keyword at a time.


News

My Stats

  • Posts - 126
  • Comments - 181
  • Trackbacks - 22

Recent Comments


Recent Posts


Archives


Post Categories


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

 

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Posted On Monday, June 11, 2007 11:42 AM
Filed Under [ all tech stuff SQL Server ]

Comments

Gravatar # re: last modified date for stored procedure
Posted by Matthew on 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
Posted by M on 1/7/2008 3:10 AM
select name, modify_date
from sys.procedures
Gravatar # re: last modified date for stored procedure
Posted by AQ123 on 3/16/2008 11:03 AM
Thanks, solve our porblem
Gravatar # re: last modified date for stored procedure
Posted by Mayank Parmar on 9/7/2008 8:20 PM
Thanks, this worked for me.
Gravatar # re: last modified date for stored procedure
Posted by jkar on 1/21/2009 3:12 AM
Nice! Thanx mate...
Gravatar # re: last modified date for stored procedure
Posted by Dinuke on 4/27/2009 4:41 AM
Thanks for the post. Cheers.
Gravatar # re: last modified date for stored procedure
Posted by Syed Muhammad Ahsan Arif on 10/8/2009 6:48 PM
Thanks mate. nice work
Gravatar # re: last modified date for stored procedure
Posted by Padmini on 10/21/2009 6:59 PM
thanks a lot.. special thanks to M
Gravatar # re: last modified date for stored procedure
Posted by jzapp on 4/16/2010 6:08 AM
You can also add "Date Last Modified" to the object explorer details view in SQL Management Studio 2008.
Gravatar # re: last modified date for stored procedure
Posted by Marios Philippopoulos on 2/22/2011 5:09 AM
Is there a way to also get the actual login that did the modification?
Gravatar # re: last modified date for stored procedure
Posted by jp on 5/31/2011 12:00 AM
thanks for posting - very useful.
Gravatar # re: last modified date for stored procedure
Posted by Lor on 6/29/2011 5:28 PM
Is there a way to also get the actual login that did the modification?
Gravatar # re: last modified date for stored procedure
Posted by vasya on 6/30/2011 12:12 AM
select * from sys.objects
Gravatar # re: last modified date for stored procedure
Posted by Alex on 6/30/2011 6:08 AM
@Lor: Not that I know of.
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: