How to know who deleted a table?

Hi All,
I got an emergency problem! A table was deleted by someone, but I
don't know who did this. How can I know it in SQL Server 2000?
Thanks in advance!
NateTry Lumigent's Log Explorer:
www.lumigent.com
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Mike" <npei72@.yahoo.com> wrote in message
news:acead494.0401151057.76a339f0@.posting.google.com...
Hi All,
I got an emergency problem! A table was deleted by someone, but I
don't know who did this. How can I know it in SQL Server 2000?
Thanks in advance!
Nate

How to know which user has deleted some lines in a table

Hello all
I don't know how but has disapeared some lines in a table and I want to know wich user has deleted them, do you know how can I do that? how can I try to analize the log
Thank you very much in advance
Paloma.Do you do log backups..? If so it will be possible to read the transaction
log with a 3rd party tool lumigent log explorer, this will give you the info
you require.
--
HTH
Ryan Waight, MCDBA, MCSE
"Paloma" <palo_palo70@.hotmail.com> wrote in message
news:2F2D1ED2-71F9-4369-A33C-3E932B505168@.microsoft.com...
> Hello all,
> I don't know how but has disapeared some lines in a table and I want to
know wich user has deleted them, do you know how can I do that? how can I
try to analize the log?
> Thank you very much in advance.
> Paloma.|||The only way unless you have some built in auditing is to use a 3rd party
tool available from www.lumigent.com
Andrew J. Kelly
SQL Server MVP
"Paloma" <palo_palo70@.hotmail.com> wrote in message
news:2F2D1ED2-71F9-4369-A33C-3E932B505168@.microsoft.com...
> Hello all,
> I don't know how but has disapeared some lines in a table and I want to
know wich user has deleted them, do you know how can I do that? how can I
try to analize the log?
> Thank you very much in advance.
> Paloma.