Anyway to find informatoin on how a record is deleted?

Hi,
One record, linked by a key tid, is deleted from several tables in the
database. Is there anyway to find information on when and who deleted the
recrod from SQL server?
Thanks,
AlphaYou can use a log viewing tool, such as:
Apex SQL Log
http://www.apexsql.com/index.asp?PageId=apex_sql_log&TitleID=products
Lumigent Log Explorer
http://www.lumigent.com/products/le_sql.html
Log P.I.
http://www.logpi.com/
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:B6572BE4-B0FE-4034-976F-EA21D1C5CC8F@.microsoft.com...
> Hi,
> One record, linked by a key tid, is deleted from several tables in the
> database. Is there anyway to find information on when and who deleted the
> recrod from SQL server?
> Thanks,
> Alpha

Anyway to find informatoin on how a record is deleted?

Hi,
One record, linked by a key tid, is deleted from several tables in the
database. Is there anyway to find information on when and who deleted the
recrod from SQL server?
Thanks,
Alpha
You can use a log viewing tool, such as:
Apex SQL Log
http://www.apexsql.com/index.asp?Pag...tleID=products
Lumigent Log Explorer
http://www.lumigent.com/products/le_sql.html
Log P.I.
http://www.logpi.com/
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:B6572BE4-B0FE-4034-976F-EA21D1C5CC8F@.microsoft.com...
> Hi,
> One record, linked by a key tid, is deleted from several tables in the
> database. Is there anyway to find information on when and who deleted the
> recrod from SQL server?
> Thanks,
> Alpha

Anyway to find informatoin on how a record is deleted?

Hi,
One record, linked by a key tid, is deleted from several tables in the
database. Is there anyway to find information on when and who deleted the
recrod from SQL server?
Thanks,
AlphaYou can use a log viewing tool, such as:
Apex SQL Log
http://www.apexsql.com/index.asp?Pa...itleID=products
Lumigent Log Explorer
http://www.lumigent.com/products/le_sql.html
Log P.I.
http://www.logpi.com/
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:B6572BE4-B0FE-4034-976F-EA21D1C5CC8F@.microsoft.com...
> Hi,
> One record, linked by a key tid, is deleted from several tables in the
> database. Is there anyway to find information on when and who deleted the
> recrod from SQL server?
> Thanks,
> Alpha