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: | 325 |
Nodes: | 16 (2 / 14) |
Uptime: | 76:41:37 |
Calls: | 7,164 |
Files: | 12,542 |
Messages: | 5,533,726 |