recording query

Hello,

How can I record certain type of querys ? I would like to record
delete command sent to a specific database, and using a specific
login account.

This "query capture" should run in background because I dont know
the exact time someone will delete a record.

Im using SQL-Server 7.0

Thank you,

Eduardo.eakinto@.buscape.com.br (Eduardo) wrote in message news:<693f7309.0404071351.dc027a@.posting.google.com>...
> Hello,
> How can I record certain type of querys ? I would like to record
> delete command sent to a specific database, and using a specific
> login account.
> This "query capture" should run in background because I dont know
> the exact time someone will delete a record.
> Im using SQL-Server 7.0
> Thank you,
> Eduardo.

Profiler would be the first place to look, or perhaps a trace.

Simon