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 |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2004-11-29 : 17:31:22
|
| I've double clicked on a process in management-current activity-process info (within enterprise manager) and it shows me the last t-sql command, or at least shows me part of it (it's cutting of part of the select statement). Is there a way to see the complete last/current t-sql command for a process? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-29 : 17:34:27
|
| Run DBCC INPUTBUFFER in Query Analyzer. You'll need to pass the spid. QA, by default, will only show the first 256 characters. To change that, tools..options..results.Tara |
 |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2004-11-29 : 18:37:59
|
| Thanks Tara, I think that's going to work.Another question...(I'm sure I'm overlooking the obvious, but) On the results from the DBCC command, it displays in query analyzer with the EventInfo trailing off into ...I can drag the result column to the end of the page with my cursor and display more information, but not the entire column (ie. I can't scroll to the right). What setting do I have to adjust to fix this? I set the max char per column to 2000, so I should be getting the full results now. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-29 : 18:43:35
|
| Hit CTRL+T to get into text mode out of grid mode. It's also available in the Query menu.Tara |
|
|
|
|
|
|
current activity process info in enterprise mgr