Transactions

A client of mine recently discovered that certain records were deleted
on their SQL 2000 server. Is there a utility that I can use to look
back at the transactions to find out what happened to those records
(i.e. who/what deleted them and/or what time)?

Assuming the log records still exists in the transaction log, you can use an
y of the log reader
tools. I listed some on my links page: http://www.karaszi.com/SQLServer/li...ver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/


<vnegri@gmail.com> wrote in message news:1141114977.549635.31370@v46g2000cwv.googlegroups.c
om...
>A client of mine recently discovered that certain records were deleted
> on their SQL 2000 server. Is there a utility that I can use to look
> back at the transactions to find out what happened to those records
> (i.e. who/what deleted them and/or what time)?
>

Below are few Log Reader tools.

Apex SQL Log
Log Explorer
Log P.I.
SQL Log Rescue

http://aspfaq.com/show.asp?id=2449

Log Explorer is simple one to use.

--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and 
time
asking back if its 2000 or 2005]



"vnegri@gmail.com" wrote:

> A client of mine recently discovered that certain records were deleted
> on their SQL 2000 server. Is there a utility that I can use to look
> back at the transactions to find out what happened to those records
> (i.e. who/what deleted them and/or what time)?
>
>

Thanks!