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: | 251 |
Nodes: | 16 (3 / 13) |
Uptime: | 15:26:22 |
Calls: | 5,567 |
Calls today: | 6 |
Files: | 11,682 |
Messages: | 5,125,819 |
Posted today: | 1 |