Greetings,
MicroSoft SQL 6.x has a 'dbcc inputbuffer (spid)' command that dumps out the first portion of command buffer for the specfied spid. This is a 'undocumented' MS SQL dbcc command.
Is there an equivalent commad for Sybase 11.5?
TIA
jkobie@bigfoot.com
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading
On Friday, April 10, 1998 at 12:00:00 AM UTC-7, jko...@bigfoot.com wrote:
Greetings,
MicroSoft SQL 6.x has a 'dbcc inputbuffer (spid)' command that dumps out the
first portion of command buffer for the specfied spid. This is a 'undocumented' MS SQL dbcc command.
Is there an equivalent commad for Sybase 11.5?
TIA
jkobie@bigfoot.com
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading
Is this similar to EXEC sp_showplan <spid>, NULL, NULL, NULL
That gives the showplan for what is currently running on that spid.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 465 |
Nodes: | 16 (2 / 14) |
Uptime: | 07:51:00 |
Calls: | 9,391 |
Files: | 13,566 |
Messages: | 6,096,179 |