sys.sysprocesses(stmt_start,stmt_end)

• koteswara kishore K.

  Ten Centuries

  Points: 1122

  More actions

  April 9, 2009 at 1:32 am

  #155539

  Hi Flocks,

  While execute below statement

  select * from sys.sysprocesses where dbid=db_id('abcedfgh') and spid=114

  There is two cloumns stmt_start,stmt_end. where i can find(table) for statements? using those two columns.

  Help me.

  Thanks,

  KK.

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  April 9, 2009 at 3:06 am

  #974898

  If you need the sql statement that executed you need to pass the sql_handle to sys.dm_exec_sql_text using cross apply. Check BOL for examples.

  "Keep Trying"

• koteswara kishore K.

  Ten Centuries

  Points: 1122

  More actions

  April 9, 2009 at 10:47 pm

  #975561

  Thanks, I got it.

  KK