INF: SQL Server SELECT with HOLDLOCK Transaction Information

ID: Q62859

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2

The following information describes what happens when a SELECT is done with HOLDLOCK.

If you do a SELECT with HOLDLOCK within a transaction and get no hits, either an index page or the whole table will be locked until commit.

If the optimizer used a unique index to process the select, the index page where the missing item belongs will be locked. If the optimizer did not use a unique index to process the query, the entire table will be locked.

Additional query words: Transact-SQL


Keywords          : kbprg SSrvServer 
Version           : 4.2 4.2a 4.2b
Platform          : OS/2 
Issue type        :

Last Reviewed: March 9, 1999