I have very basic table CREATE TABLE [dbo].[Table_1]( [Test] [int] NULL) & sp_configure'block process threshold', 1 --> 1 sec go
To create blocking, in 1 session i executed
Begin tran Update [dbo].[Table_1] set [Test]=1
and another session select * from [dbo].[Table_1]
when i setup extended events, i got below
select * from [dbo].[Table_1] **DECLARE @edition sysname; SET @edition = cast(SERVERPROPERTY(N'EDITION') as sysname); select case when @edition = N'SQL Azure' then 2 else 1 end as 'DatabaseEngineType'****From which sky <<< DECLARE @edition sysname; ... came while it should be Update statement....
Please help