suppose if i am using rowlock in following manner SELECT OrderID FROM Orders WITH( holdlock , ROWLOCK) WHERE OrderID =100 then can u please tell me ..... untill how much it will hold this lock . because as soon as i execute this query ; simultaneously i can select the same query from another page. that means it is not holding a lock ... SO PLEASE ME HELP OUT....... PLEASE REPLY ME AS SOON AS POSSIBLE THANKS IN ADVANCE