Groups | Search | Server Info | Login | Register

Groups > comp.databases.sybase > #713

Re: dbcc inputbuffer ?

Show all headers | View raw

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

Back to comp.databases.sybase | Previous | Next — Previous in thread | Find similar

Thread

Re: dbcc inputbuffer ? ray@bicanet.com - 2017-12-28 10:48 -0800
  Re: dbcc inputbuffer ? bret_halford@msn.com - 2018-05-31 09:02 -0700

csiph-web