asubra
July 15th, 2003, 02:40 AM
hi there,
i need some guidance on the MSSQL Rowlock.
I'm using the command
set transaction isolation level serializable
BEGIN TRAN
select statement...
COMMIT TRAN // when want to release the lock
Prob:
The above statements will lock the records that are accessed using select statement above,
if another person accessing the same record, MSSQL won't allow to lock the record but can be accessed using select statement as usual.
But the problem is, how do i check whether that record is locked or not ?
because when an application locks that rows, others can't access the same rows. Is there any SQL statements that can be used to check whether that records are locked or not ?
TQVM
i need some guidance on the MSSQL Rowlock.
I'm using the command
set transaction isolation level serializable
BEGIN TRAN
select statement...
COMMIT TRAN // when want to release the lock
Prob:
The above statements will lock the records that are accessed using select statement above,
if another person accessing the same record, MSSQL won't allow to lock the record but can be accessed using select statement as usual.
But the problem is, how do i check whether that record is locked or not ?
because when an application locks that rows, others can't access the same rows. Is there any SQL statements that can be used to check whether that records are locked or not ?
TQVM