<deadlock><victim-list><victimProcess id="process2033f8f3468" /></victim-list><process-list><process id="process2033f8f3468" taskpriority="0" logused="0" waitresource="OBJECT: 7:542624976:25 " waittime="311" ownerId="3669452337" transactionname="CMetadataAccessor::CMetadataAcce" lasttranstarted="2021-04-22T07:09:30.230" XDES="0x23d496c5ac0" lockMode="Sch-S" schedulerid="26" kpid="3120" status="suspended" spid="204" sbid="1" ecid="0" priority="0" trancount="0" lastbatchstarted="2021-04-22T07:09:16.073" lastbatchcompleted="2021-04-22T07:09:16.073" lastattention="1900-01-01T00:00:00.073" clientapp="Microsoft SQL Server" hostname="GS1" hostpid="6804" loginname="ls" isolationlevel="read committed (2)" xactid="3669433242" currentdb="7" currentdbname="web" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"><executionStack><frame procname="unknown" line="9" stmtstart="340" stmtend="6048" sqlhandle="0x0300ff7f773d64f2fbe9e700caac000001000000000000000000000000000000000000000000000000000000">
unknown    </frame></executionStack><inputbuf>
Proc [Database Id = 32767 Object Id = -228311689]   </inputbuf></process><process id="process2033e41fc28" taskpriority="0" logused="0" waitresource="OBJECT: 7:542624976:25 " waittime="12900" ownerId="3669448092" transactionname="SELECT" lasttranstarted="2021-04-22T07:09:17.640" XDES="0x23cf7468e20" lockMode="Sch-S" schedulerid="26" kpid="16724" status="suspended" spid="282" sbid="2" ecid="0" priority="0" trancount="0" lastbatchstarted="2021-04-22T07:09:17.647" lastbatchcompleted="2021-04-22T07:09:17.647" lastattention="1900-01-01T00:00:00.647" clientapp=".Net SqlClient Data Provider" hostname="GS78" hostpid="6260" loginname="memlg" isolationlevel="read committed (2)" xactid="3669448092" currentdb="7" currentdbname="web" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"><executionStack><frame procname="unknown" line="1" stmtstart="56" stmtend="210" sqlhandle="0x020000001220de3193b8aae3d773af6056385728dd029aa10000000000000000000000000000000000000000">
unknown    </frame><frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown    </frame></executionStack><inputbuf>
(@Accounts nvarchar(4000))SELECT State FROM Users with(nolock) where Accounts=@Accounts   </inputbuf></process><process id="process23c7b587848" taskpriority="0" logused="13480" waitresource="KEY: 7:281474978938880 (930640aebe39)" waittime="14064" ownerId="3669436841" transactionname="ALTER TABLE" lasttranstarted="2021-04-22T07:09:16.473" XDES="0x23dd4dc0420" lockMode="X" schedulerid="14" kpid="12676" status="suspended" spid="194" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2021-04-22T07:09:16.480" lastbatchcompleted="2021-04-22T07:09:16.480" lastattention="1900-01-01T00:00:00.480" clientapp="Microsoft SQL Server Management Studio - Query" hostname="GS2" hostpid="14652" loginname="vpn1" isolationlevel="read committed (2)" xactid="3669436841" currentdb="7" currentdbname="web" lockTimeout="4294967295" clientoption1="671090784" clientoption2="390200"><executionStack><frame procname="unknown" line="3" stmtstart="236" stmtend="352" sqlhandle="0x020000007af9b62fb4bfd1cea10c449b25bd854c10217ed20000000000000000000000000000000000000000">
unknown    </frame></executionStack><inputbuf>
IF NOT EXISTS (SELECT 1 FROM syscolumns WHERE id=object_id('Users') AND name='Counters')
BEGIN
	ALTER TABLE Users ADD Counters INT NULL
	EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Value Counter',
	@level0type=N'SCHEMA',@level0name=N'dbo',
	@level1type=N'TABLE',@level1name=N'Users',
	@level2type=N'COLUMN',@level2name=N'Counters'
END
   </inputbuf></process></process-list><resource-list><objectlock lockPartition="25" objid="542624976" subresource="FULL" dbid="7" objectname="unknown" id="lock23da51c3000" mode="Sch-M" associatedObjectId="542624976"><owner-list><owner id="process2033e41fc28" mode="Sch-S" requestType="wait" /></owner-list><waiter-list><waiter id="process2033f8f3468" mode="Sch-S" requestType="wait" /></waiter-list></objectlock><objectlock lockPartition="25" objid="542624976" subresource="FULL" dbid="7" objectname="unknown" id="lock23da51c3000" mode="Sch-M" associatedObjectId="542624976"><owner-list><owner id="process23c7b587848" mode="Sch-M" /></owner-list><waiter-list><waiter id="process2033e41fc28" mode="Sch-S" requestType="wait" /></waiter-list></objectlock><keylock hobtid="281474978938880" dbid="7" objectname="unknown" indexname="unknown" id="lock23d30145480" mode="U" associatedObjectId="281474978938880"><owner-list><owner id="process2033f8f3468" mode="S" /></owner-list><waiter-list><waiter id="process23c7b587848" mode="X" requestType="convert" /></waiter-list></keylock></resource-list></deadlock>