Wednesday, September 24, 2008

Tracing SQL Queries

Tracing SQL queries using Profiler displays the queries that get actually sent to the SQL Server.
To see the SQL queries sent by a dataset or a data adapter turn on
- Stored Procedures, RPC:Starting
- TSQL, SQL:BatchStarting

Useful columns are
  • TextData, displays the SQL query
  • SPID
  • StartTime
  • HostName, the name of the computer which sent the query

No comments: