From: Robert Dorr Sent: Friday, August 13, 2010 8:58 AMSubject: 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 AMSubject: 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?
Sent: Friday, August 13, 2010 5:41 AMSubject: 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