Groups | Blog | Home
all groups > sql server (alternate) > april 2004 >

sql server (alternate) : recording query


eakinto NO[at]SPAM buscape.com.br
4/7/2004 2:51:35 PM
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,

sql NO[at]SPAM hayes.ch
4/8/2004 1:17:54 AM
[quoted text, click to view]

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

AddThis Social Bookmark Button