dbcc inputbuffer ?

[r***@bicanet.com]

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
-----== 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.

[b***@msn.com]

Post by r***@bicanet.com

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
-----== 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.

The closest equivalent would be "dbcc sqltext (spid)"
https://wiki.scn.sap.com/wiki/display/SYBASE/DBCC+sqltext

However, selecting from the monSysSQLText table in the master database is a better solution (provides the complete statement rather than just a fragment if the statement is long).

-bret