DBCC ROWLOCK

Enables Insert Row Locking (IRL) operation on tables dynamically.

For additional syntax information for the DBCC command, see the Microsoft SQL Server Transact-SQL Reference.

Syntax

DBCC ROWLOCK (dbid, tableid, set)

where

dbid

Specifies a unique identifier for the database. This value is stored in the sysdatabases system table in the master database.

tableid

Specifies a unique identifier for the table within the database. This value is stored in the sysobjects table within each database.

set

Specifies to enable Insert Row Locking (IRL) when the value of set is 1 and to disable it when the value is 0.