--Start Blocking
BEGIN TRAN
UPDATE [AdventureWorksLT].SalesLT.Address WITH (TABLOCKX, HOLDLOCK)
SET City = 'brhahmi'
WHERE AddressID = 12

--Try access the same table
SELECT * FROM [AdventureWorksLT].[SalesLT].[Address]
--Try to verify open transaction
DBCC OPENTRAN;  
GO

---If the above DBCC Doesnt work
--use the below
Select * from sys.sysprocesses where open_tran>0; 

--verify what DBCC command's belong to what VERIFY THOSE SPID
dbcc inputbuffer (SPID)-- For the DBCC Command I did not use upperase just to show that this is not case sensitive
DBCC INPUTBUFFER (SPID)

kill SPID

-- VERIFY THE SELECT STATEMENT WICH IS STILL RUNNING STATE