Monitor SQL usage

[Kained]

Any one know of a way (free) to monitor what sql statements a program is sending to a sql server?

[Geoff]

Wireshark?

[Bromcom_John]

MSSQL Profiler is built into the Full release of SQL. This can be used to montior any and all SQL requests coming into a database.

As a component that may already be part of your install it could be considered "free".

Only operational flaw with it in your scenario is if you are trying to track the input from one particular application as Profiler logs "everything" coming into the SQL server.

 

Hope that helps

[Kained]

Thanks guys