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 don´t know
the exact time someone will delete a record.

I´m using SQL-Server 7.0

Thank you,

Eduardo.

eakinto@buscape.com.br (Eduardo) wrote in message news:<693f7309.0404071351.dc027a@posting.google.co m>...
> 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 don´t know
> the exact time someone will delete a record.
>
> I´m using SQL-Server 7.0
>
> Thank you,
>
> Eduardo.

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

Simon