CODEWITHSUNDEEP
sql-serverlogging
spoulson
spoulson

Reputation: 21601

How to log all queries sent to SQL Server from the client side?

I'm aware SQL Profiler will tell you everything you need to know about queries going on at the server side. But, can you do something similar to log queries from the client side in the SQL Native Client?

This would be helpful for tracing failing SQL statements that originate from third party assemblies, where it's not possible to step through code, in an environment where profiler access is relegated only to busy DBAs.

Upvotes: 1

Views: 875

Answers (1)

D'Arcy Rittich
D'Arcy Rittich

Reputation: 171559

Try using SqlExpressProfiler. It has worked well for me.

http://code.google.com/p/sqlexpressprofiler

Upvotes: 1

Related Questions