Try the second query that I posted. When I tried that out on my own server, it returned one row with the expected session_id and T-SQL statement.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability