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.