DBCC ROWLOCK in Microsoft SQL Server


Used for Microsoft® SQL Server™ version 6.5, enabling 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 2000 for backward compatibility of existing scripts and procedures only. In a future version of SQL Server, DBCC ROWLOCK may not be supported.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s