On Friday, April 10, 1998 at 12:00:00 AM UTC-7, [email protected] 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

[email protected]

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Thursday, December 28, 2017 at 11:48:30 AM UTC-7, [email protected] wrote:

On Friday, April 10, 1998 at 12:00:00 AM UTC-7, [email protected] 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

[email protected]

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)