recording query

[Eduardo]

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.

[Simon Hayes]

ea*****@buscape.com.br (Eduardo) wrote in message news:<69************************@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