Replay Result Set Event (Replay * Events)

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