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
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:
Post a Comment