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.