Log Analyzer for SQL 2005

Does SQL 2005 comes with log analyzer? I have not found it yet I know
for SQL2K we have lumigent and red-gate products but just curious that
MS has made any progress on this.No, same status for 2005 as for 2000.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1145279900.943559.270870@.j33g2000cwa.googlegroups.com...
> Does SQL 2005 comes with log analyzer? I have not found it yet I know
> for SQL2K we have lumigent and red-gate products but just curious that
> MS has made any progress on this.
>

Log Analyzer for SQL 2005

Does SQL 2005 comes with log analyzer? I have not found it yet I know
for SQL2K we have lumigent and red-gate products but just curious that
MS has made any progress on this.No, same status for 2005 as for 2000.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1145279900.943559.270870@.j33g2000cwa.googlegroups.com...
> Does SQL 2005 comes with log analyzer? I have not found it yet I know
> for SQL2K we have lumigent and red-gate products but just curious that
> MS has made any progress on this.
>

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