Date and time of last transaction in a given database

Hi,
Is there a query I can run to get the date and time of the last transaction
to a SQL database?
Kind of like the Last Modified date of an Acess Database.
Thanks,
Ronhi,
If you don't have triggers fitted out in your tables is very tricky to aware
of that. Do you have any chance to open QA and launch "dbcc
log(<name_of_log>,2)" statement?
Well, once done you'll see some interesting things.
Current location: Alicante (ES)
"RSH" wrote:

> Hi,
> Is there a query I can run to get the date and time of the last transactio
n
> to a SQL database?
> Kind of like the Last Modified date of an Acess Database.
> Thanks,
> Ron
>
>