View Database changes

Last Post 01 Mar 2010 06:22 AM by PaulMcKibben. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
PaulMcKibben
New Member
New Member

--
26 Feb 2010 12:08 PM
In SQL 2005, where can someone find the date that a database was changed?

The modify date for tables is in sys.objects.

Thank you.
gunneyk
New Member
New Member

--
28 Feb 2010 03:48 PM
There is no place for the modified time that I know of, only the created date. You can add DB triggers to record this but nothing built in.
PaulMcKibben
New Member
New Member

--
01 Mar 2010 06:22 AM
Gunny,

Thanks that is what I thought also.


Acceptable Use Policy
---