I am using this transaction in SQL Server Managemnet studio 2012 begin transaction Select * from tabl1 with(xlock, rowlock) where ID = 1153; select * from Table2Go to the complete details ... Bookmark It