Error message; with not much out on Google on this error
-
Hi all, Facing this weird error message, --- Msg 601, Sev 12, State 3, Line 1 : Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] --- It happens during an insert: INSERT INTO my_table(field1, field2) SELECT field1, field2 FROM v_my_table WITH (NoLock) If anyone has any insight that would be much appreciated! Thanks for your time!
-
Hi all, Facing this weird error message, --- Msg 601, Sev 12, State 3, Line 1 : Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] --- It happens during an insert: INSERT INTO my_table(field1, field2) SELECT field1, field2 FROM v_my_table WITH (NoLock) If anyone has any insight that would be much appreciated! Thanks for your time!
-
Hi all, Facing this weird error message, --- Msg 601, Sev 12, State 3, Line 1 : Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] --- It happens during an insert: INSERT INTO my_table(field1, field2) SELECT field1, field2 FROM v_my_table WITH (NoLock) If anyone has any insight that would be much appreciated! Thanks for your time!