capture query statement

[tritang]

i have a SQL server database, placed in a server computer.
other clients connect to the database, get data by different softwares.
How can I read the query statements issued from the clients?
Pls help me

 

[tlbroadbent]

What do mean, "read the query statements issued from the clients?" Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[anhtri]

the clients running an application connect to the database, issue a statement ( for example, show a report ) to the server to get data.
From the server, can i know which statement was issued? (what is the question that was asked from the client?)
thank you!

 

[tlbroadbent]

Do yo want to see a trace of the SQL statements issued by the clients? What is the purpose of capturing the SQL statements? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[anhtri]

yes Terry, I want to see the traces of the SQL statement issued by the clients.
i want to test the application, to be sure that it does issue the correct SQL statements
thank you
anhtri

 

[tlbroadbent]

Use the SQL Profiler. SQL Profiler is one of the SQL Client tools. It can be installed along with Enterprise Manager, Query Analyzer, etc.

SQL BOL contains the detailed information about SQL Profiler. Check the following topic.

Monitoring with SQL Profiler

http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_86ib.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[anhtri]

i can get it now Terry
thank you very much!!!