jason.triplett

Comments

  • Here's what I'm using since we upgraded to 9: AND s.spid LIKE '%' union all SELECT s1.loginame ,DB_NAME(s1.dbid) NAME ,s1.hostname ,s1.program_name ,isnull(r.sql_handle, s1.sql_handle) as sql_handle ,isnull(r.statement_start_offset, s1.stmt_start) as stmt_start ,isnull(r.statement_end_offset, s1.stmt_end) as stmt_end…