Replay Result Set Event (Replay * Events)

Published Jan 15 2019 01:11 PM 84 Views
Microsoft
First published on MSDN on Aug 13, 2010

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

Version history
Last update:
‎Jan 15 2019 01:11 PM
Updated by: