469,167 Members | 1,399 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

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.
Jul 20 '05 #1
1 1133
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 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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jussi Rasku | last post: by
6 posts views Thread by Dovelet | last post: by
3 posts views Thread by Chris Thompson | last post: by
1 post views Thread by nglmartin | last post: by
reply views Thread by Mad Scientist | last post: by
1 post views Thread by Bill | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.