Row Lock reading SQL server records
Row Lock reading SQL server records
(OP)
How do I prevent Crystal queries from locking out normal user updates. eg. I would like to read reference all of the records and not stop our normal updates to the table(s).
A dba here advises it takes a stored procedure with appropriate coding to read without locking. Is there a way I can do it without using a stored procedure?
A dba here advises it takes a stored procedure with appropriate coding to read without locking. Is there a way I can do it without using a stored procedure?
RE: Row Lock reading SQL server records
Technically, I don't think that the rows are being locked, I think that since it's a read only query, it might be locking pages.
-k