Tagged Questions
7
votes
2answers
6k views
Could not continue scan with NOLOCK due to data movement
We run SQL Server 2000 and we get a few of these errors every night.
Could not continue scan with NOLOCK due to data movement
The query that throws this error is a large complex query that joins ...
3
votes
1answer
391 views
Using (NOLOCK) in a READ COMMITTED transaction block
We're using SQL Server 2000.
I'm wondering what the risks are if we use a NOLOCK hint within a READ COMMITTED transaction block, for example:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
GO
BEGIN ...
