Could not continue scan with NOLOCK due to data movement error

Could not continue scan with NOLOCK due to data movement error

Post by Chad » Thu, 13 Nov 2003 08:27:30


I'm trying to create a snapshot replication and when I
start the agent, it runs fine for a while and then stops
and errors out with:

Error Message:
The process could not bulk copy out of table '[dbo].
[syncobj_0x4141444143413832]'.

Error Details:
Could not continue scan with NOLOCK due to data movement.
(Source: ATG-SQL-6 (Data source); Error number: 601)

This only seems to happen when I include some User Defined
Functions in the publication.

Does anyone have any suggestions?

Thank you.