I want to find out when a database was last updated.

I checked in IE, it shows the creation time and the time last backup was
taken.

I looked at the timestamp of the database, that doesn't seem to reflect the
correct date and time, in my case it is showing the date of 12/4/2005 11:00am
whereas I know for sure that the database is being updated since after that.

That was the time I took last backup of this database.

Thank you in advance,
-Me

Unless you have a trace running you can't. Trace is your best bet to see
if and when a db is being accessed. You can also potentially use some of
the third party Log viewer tools.

--
Andrew J. Kelly SQL MVP


"Me" <Me (AT) discussions (DOT) microsoft.com> wrote