Log all commands executed in QA

Hi All,

Is there way that commands executed in the query analyzer get logged
automatically?

TIA

JorizWhat do you want to do? Give more details

Madhivanan|||You can capture any SQL statements using SQL Profiler if that helps.

--
David Portas
SQL Server MVP
--|||(google@.joriz.is-a-geek.net) writes:
> Is there way that commands executed in the query analyzer get logged
> automatically?

In Control Panel, ODBC Sources under the Tracing tab, you can turn on
ODBC tracing. However, this level is on lower level on commands and
I believe it's mainly intended to debug ODBC drivers. But I believe
that you should be able to find the commands there.

However, I doubt that you want to use this. I turned it on to test
before I wrote this reply. And Query Analyzer become just amazingly
slow! A simple query that normally would return instantly, ran for
more than five seconds!

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp