Wednesday, March 21, 2012

Install Error - 'NOLOCK'

I get the following error when installing SQL Server Express SP2 on Windows
XP SP2 with all current updates. The only other thing installed is .NET 2.0.
Does anyone know how to resolve the issue.
[Microsoft][SQL Native Client][SQL Server]Could not continue scan with NOLOCK
due to data movement
Thanks,
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-msde/200706/1
jwbutler,
I do not know, but I have would ask: Is your SQL Express engine still
running when you apply SP2?
The error reported is one that SQL Server throws when SELECTing with NOLOCK
and the data is deleted during a narrow window of time, as described here:
http://support.microsoft.com/kb/815008. Could that be happening to you? If
so, shut down SQL Express and try the update.
RLF
"jwbutler via droptable.com" <u16619@.uwe> wrote in message
news:7455d61651947@.uwe...
>I get the following error when installing SQL Server Express SP2 on Windows
> XP SP2 with all current updates. The only other thing installed is .NET
> 2.0.
> Does anyone know how to resolve the issue.
> [Microsoft][SQL Native Client][SQL Server]Could not continue scan with
> NOLOCK
> due to data movement
> Thanks,
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server-msde/200706/1
>
sql

No comments:

Post a Comment