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.