Replay Result Set Event (Replay * Events)

  • Article

From: Robert Dorr
Sent: Friday, August 13, 2010 8:58 AM
Subject: RE: SQL Server Trace Replay - "Replay Result Set Event"

 The Result Set event is one of several client side replay events. 

 Here are some of Common Result Event Columns

 Text
 
 Returned values for example 
 DECLARE @edition sysname; SET @edition = cast(SERVERPROPERTY(N'EDITION') as sysname); select case when @edition = N'SQL Azure' then 1 else 0 end as 'IsCloud'
 -    RETURNS - 
 IsCloud as column name in result set event  
 IsCloud = 0 as value in result row event 
 SPID
 
 Session Id from the ORIGINAL Trace
 
 IntegerData
 
 SPID used during REPLAY
 
 LoginName
 
 Database User
 
 DBID
 
 Database Id
 
 DBNAME
 
 Database Name
 
 Handle
 
 Handle of prepare / cursor if used
 
 BatchId
 
 Mars Batch Id
 
  

Sent: Friday, August 13, 2010 5:41 AM
Subject: SQL Server Trace Replay - "Replay Result Set Event"

Does anyone has a description what I get back in details in the SQL Trace "Replay Result Set Event"? A description of the returned columns would be fine, especially I am interested in the columns “IntegerData” - what does this retuned number mean?

Bob Dorr - Principal SQL Server Escalation Engineer