How to find out when a database was last updated

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@.discussions.microsoft.com> wrote in message
news:F89147AA-3F98-4ECC-8981-27854F64F5C6@.microsoft.com...
>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
>

How to find out when a database was last updated

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:00a
m
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,
-MeUnless 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@.discussions.microsoft.com> wrote in message
news:F89147AA-3F98-4ECC-8981-27854F64F5C6@.microsoft.com...
>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
>