1. Forum
  2. Usenet
  3. COMP.DATABASES.SYBASE

  • dbcc inputbuffer ?

    From ray@bicanet.com@21:1/5 to jko...@bigfoot.com on Thu Dec 28 10:48:28 2017
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From bret_halford@msn.com@21:1/5 to r...@bicanet.com on Thu May 31 09:02:26 2018
    On Thursday, December 28, 2017 at 11:48:30 AM UTC-7, r...@bicanet.com wrote:
    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.

    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)