How to spy all actions done to my db 1

[mfranck]

Hi there

I would need to spy all actions (specially insert/ update statements) that have been done against my db. They are carried out by a third party software and I'm trying to figure out what exactly it is doing in the db.

I hear using querry analizer is a way, but I can't figure out how.

Thank you for your help

Cheers

 

[bertrandkis]

You cannot track queries that are executed against your DB using Query Analyser, You have to use SQL PROFILER. To know how to use it:Type SQL Profiler as your search key word in BOL and create trace as a subtopic. Make sure that you specify as many filters as possible other wise you will get a lot of data that you do not need.
Bertrandkis
SQL Wizard