How can I see the complete running SQL Statement in SQL Server 2000?

• rmaggio

  SSC-Addicted

  Points: 437

  More actions

  September 29, 2008 at 9:51 am

  #92495

  I'm trying to assist in debugging a sql issue on a SQL Server 2000 box. Using Enterprise Manager, if I look at Current Activity> Process Info and click on the running process, I only see a small portion of the expected sql statement. Is there a way to see the whole statment? I'm not that familiar with the sql server env, so I don't know where to find this. This is a vendor application, so I can't see the source code that's generating the statement. I need to see it, as it's running, similarly to Oracles OEM.

  Thanks

  Bob
  Not a downstroke, fistpicker

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  September 29, 2008 at 3:06 pm

  #878632

  Check this out:

  http://vyaskn.tripod.com/fn_get_sql.htm

  MJ

• Rajesh kasturi

  SSCarpal Tunnel

  Points: 4007

  More actions

  September 30, 2008 at 3:36 am

  #878733

  use DBCC INPUTBUFFER(SPID)

  Rajesh Kasturi