last update of database

DB - SQL2000 or SQL7
OS - W2K or NT
Is there a sp or any way to check when a database is last accessed by or
updated by user ?
TIA
No, SQL Server doesn't track this information, unless you want to use a
third party tool to review the transaction logs. You can put code into your
own procedures, or triggers on tables if you for some reason allow direct
access to tables, to track whatever components of the transaction you like.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:e7DI$JeNEHA.556@.tk2msftngp13.phx.gbl...
> DB - SQL2000 or SQL7
> OS - W2K or NT
>
> Is there a sp or any way to check when a database is last accessed by or
> updated by user ?
> TIA
>
>

last update of database

DB - SQL2000 or SQL7
OS - W2K or NT
Is there a sp or any way to check when a database is last accessed by or
updated by user ?
TIANo, SQL Server doesn't track this information, unless you want to use a
third party tool to review the transaction logs. You can put code into your
own procedures, or triggers on tables if you for some reason allow direct
access to tables, to track whatever components of the transaction you like.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:e7DI$JeNEHA.556@.tk2msftngp13.phx.gbl...
> DB - SQL2000 or SQL7
> OS - W2K or NT
>
> Is there a sp or any way to check when a database is last accessed by or
> updated by user ?
> TIA
>
>