Monday, March 19, 2012

Intercept SQL Queries sent to DB

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!Vlade writes:
> 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.

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/techin.../2000/books.asp

No comments:

Post a Comment