BEGIN TRAN SELECT * FROM dbo.Item WAITFOR DELAY '00:00:10' --wait for 10 seconds SELECT * FROM dbo.Item COMMIT