Wednesday, March 7, 2012

log deleted row

Is it possible to find who was deleted row from sql server 2000 with t-sql,
query analyzer?If you haven't logged this yourself (using, for instance triggers), your only hope would be to use a
3rd party tool to explore the transaction log. This requires the log records to still exists in the
transaction log. I've listed some such tools at http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nikolami" <nikolami@.nyc.com> wrote in message news:dv3qck$493$1@.ss405.t-com.hr...
> Is it possible to find who was deleted row from sql server 2000 with t-sql,
> query analyzer?
>

No comments:

Post a Comment