Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blackd77
Starting Member
9 Posts |
 Posted - 2007-11-01 : 12:03:46
|
| Hello. I'm in need of viewing the entire query used by an application we have the uses SQL server, rather than (in this case) just part of it, when I view the query from Enterprise Manager's "Process Details". How does one go about viewing the entire query? Thanks in advance! |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-11-01 : 12:04:26
|
| You could run a trace. |
 |
|
|
blackd77
Starting Member
9 Posts |
Posted - 2007-11-01 : 12:27:28
|
| Thanks. I found a "step-by-step" from TechRepublic, but I have questions about the event classes...I'm unsure which one(s) if any I should choose. The data columns tab in the example has SPID highlighted. I can select SPID = 78 in the Filters tab, but I'm still left with the question of which events to capture: SQL:StmtStarting? SQL:StmtCompleted? SQL:BatchStarting? Something else? The context help has this to say about Trace/TSQL:Collection of event classes produced by the execution of Transact-SQL statements passed to an instance of SQL Server from the client. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-11-01 : 13:19:11
|
| use RPC:Completed and SQL:BatchCompleted |
|
|
|
blackd77
Starting Member
9 Posts |
Posted - 2007-11-01 : 14:28:52
|
| That worked beautifully! Thank you. |
|
|
|
|
|
|
Overcoming a 255-byte limit on viewing queries