Open Query Analyzer

- open two connections
- select number 1, run this

USE Northwind
BEGIN TRAN
SELECT * FROM dbo.Categories (UPDLOCK,ROWLOCK) WHERE CategoryID=3

- select number 2, run this

USE Northwind
BEGIN TRAN
SELECT * FROM dbo.Categories (UPDLOCK,ROWLOCK) WHERE CategoryID=3
ROLLBACK

You can see session 2 i locked

- select number 1, run this

ROLLBACK

You can see session 2 continue

Fabio