View Database changes

Last Post 01 Mar 2010 06:22 AM by PaulMcKibben. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
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.
You are not authorized to post a reply.

Acceptable Use Policy