Re: dbcc inputbuffer ?

21 views
Skip to first unread message

r...@bicanet.com

unread,
Dec 28, 2017, 1:48:30 PM12/28/17
to
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
>
> jko...@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.

bret_h...@msn.com

unread,
May 31, 2018, 12:02:27 PM5/31/18
to
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
Reply all
Reply to author
Forward
0 new messages