DBCC ROWLOCK (T-SQL)

Used for Microsoft® SQL Server™ version 6.5, enabled Insert Row Locking (IRL) operations on tables.


Important Row-level locking is enabled by default in SQL Server. The locking strategy of SQL Server is row locking with possible promotion to page or table locking. DBCC ROWLOCK does not alter the locking behavior of SQL Server (it has no effect) and is included in Microsoft SQL Server version 7.0 for backward compatibility of existing scripts and procedures only. In a future version of SQL Server, DBCC ROWLOCK may not be supported.


See Also
Architecture Enhancements DBCC

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.