info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: dbcc inputbuffer ?
26 views
Skip to first unread message
r...@bicanet.com
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.
> 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
May 31, 2018, 12:02:27 PM5/31/18
to
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
0 new messages