SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 When was db object last updated?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sql_er
Constraint Violating Yak Guru

251 Posts
Posted - 04/04/2007 :  12:36:29  Show Profile  Reply with Quote
Guys,

Is there a way to find out when a certain DB object (e.g. Stored procedure) was last modified?

SYSOBJECTS table contains crdate and refdate fields. None of these, however, appear to tell me when when the object was last updated.

Is there a way to find that out?


Thanks a lot

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts
Posted - 04/04/2007 :  12:37:50  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Try to search SQLTeam. This has been discussed numerous times not long ago.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

X002548
Not Just a Number

15586 Posts
Posted - 04/04/2007 :  13:13:28  Show Profile  Reply with Quote
The answer is no in 2000, and I believe yes in 2k5



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

sql_er
Constraint Violating Yak Guru

251 Posts
Posted - 04/04/2007 :  14:03:16  Show Profile  Reply with Quote
Thanks Peso and Brett.

Yes, according to the following, it seems that 2000 does not allow it: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79750
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2871 Posts
Posted - 04/04/2007 :  15:53:49  Show Profile  Visit jezemine's Homepage  Reply with Quote
in 2005 there is a modify_date in sys.objects

http://msdn2.microsoft.com/en-us/library/ms190324.aspx

www.elsasoft.org
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 04/05/2007 :  03:06:27  Show Profile  Reply with Quote
See:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59029
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=34415
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56370
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=34014
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77211
Go to Top of Page

sql_er
Constraint Violating Yak Guru

251 Posts
Posted - 04/07/2007 :  15:12:58  Show Profile  Reply with Quote
Thanks for the enlightment folks!

Jezemine: I'll keep this in mind in case my company migrates to 2005.

Kristen: Great links ... I'm currently reading and learning from them ...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000