Connecting Tech Pros Worldwide Help | Site Map

Intercept SQL Queries sent to DB

Vlade
Guest
 
Posts: n/a
#1: Jul 20 '05
Anybody know of a way to view SQL Queries sent to a SQL Server 2000
box ?

I have tried using the 'current activity' option in enterprise
manager, and ODBC tracing but neither show the queries made by this
3rd party app.

I have no db schema and wondered if there was a tool to let me see the
queries sent to my sql server.

Thanks!
Erland Sommarskog
Guest
 
Posts: n/a
#2: Jul 20 '05

re: Intercept SQL Queries sent to DB


Vlade writes:[color=blue]
> Anybody know of a way to view SQL Queries sent to a SQL Server 2000
> box ?
>
> I have tried using the 'current activity' option in enterprise
> manager, and ODBC tracing but neither show the queries made by this
> 3rd party app.
>
> I have no db schema and wondered if there was a tool to let me see the
> queries sent to my sql server.
>[/color]

Take a look at the Profiler. You find it in the SQL Server program
group.

--
Erland Sommarskog, SQL Server MVP,

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