Hi
Chithuu...
This
is what is stated in the Transact-SQL Help:
"
DBCC
ROWLOCK:
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.
"
/S
To change your membership options, refer to:-----Ursprungligt meddelande-----
Fr�n: Chitrapandian N [mailto:[EMAIL PROTECTED]]
Skickat: den 28 maj 2002 08:25
Till: JDJList
�mne: [jdjlist] Row level locking in Microsoft SQL Server 7.0 ..!
Hi..,
How can I configure the row level locking at server (Microsoft SQL Server 7.0) level. By default when I insert a record or edit a record it locks the whole page. But at the same time if more than one user tries to insert the record or edit two consecutive records it does not responds immediately to the second user and seems to be hanging. How to set Row-level locking as a default ..?? any configuration details..??Thanks in advance..
Chithuu.. To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
http://www.sys-con.com/java/list.cfm
