Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Row Lock reading SQL server records

Status
Not open for further replies.

rsiedlik

MIS
Nov 30, 2004
1
0
0
US
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?
 
What your DBA is referring to is a dirty read, and I believ she/he is correct.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top