Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nitzos
Starting Member
2 Posts |
 Posted - 2003-08-13 : 05:25:12
|
| My SQL version is: Microsoft SQL Server 7.00 - 7.00.1063 The error is Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601). The step failed.I take it in a simple Select When I do Stop and Start It work goodWhat happen ? |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-08-13 : 05:36:13
|
Read the help file...quote:
ExplanationWhen scanning with the NOLOCK locking hint or with the transaction isolation level set to READ UNCOMMITTED, it is possible for the page at the current position of the scan to be deleted. When this happens, Microsoft® SQL Server™ is not able to continue the scan.ActionThis error aborts the query. Either resubmit the query or remove the NOLOCK locking hint.
-------Moo. :) |
 |
|
|
nitzos
Starting Member
2 Posts |
Posted - 2003-08-14 : 03:27:37
|
| OK, but the problem arrive to me without any Lock hint. I mean, Select statement doesn't work. After Start and Stop a can do my Select statment good. Any other tip ????Thanks |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-08-14 : 04:04:21
|
| I suspect you have some pessimistic locks on your data, or extremely long-running transactions. You need to review your architecture and cut down on transaction running times.Owais |
|
|
|
|
|
|
NOLOCK Error