How to log, trace or get queries that an application send to Microsoft SQL Server 2008 thru ODBC driver (without modifying application...)
Maybe it can be done with SQL Server itself or ODBC has some query logging?
+2
A:
@davispuh, you can use the SQL Profiler to trace SQL statements. you can also use the ODBC Tracing.
RRUZ
2010-04-28 20:50:06
Thanks, this is what I was looking for :)Only Profiler shows successful queries?, but how to see failed queries or unsuccessful authorization, Access Denied..Or if I use Oracle or other with ODBC (I'm just curious)
davispuh
2010-04-28 21:00:17