I tried to create similar scenario but no luck, Can any one help me to recreate same

/************************************

create Database Deadlock_Check

GO

use Deadlock_Check

GO

Create Procedure Deadlockproc

as

Begin

Create table #emp (id int , name varchar (200))

Insert into #emp values (1, 'deadlock')

Alter table #emp Alter column name varchar (201)

Insert into #emp values (2, 'deadlock')

End

Go

Exec Deadlockproc

/**********************************/

Thanks

Saurabh Sinha

My Blog