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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 SQL Server Error

Author  Topic 

JenniferK
Starting Member

2 Posts

Posted - 2013-02-18 : 07:18:48
Hi all,

Does anyone know what it means if you get this in your error logs:
SQL Error: 601, SQLState: S1000
Could not continue scan with NOLOCK due to data movement.

We are trying to publish from a content management system to a database which was working fine but has now stopped. We do not have many permissions on the database so do not know if the IT teams have changed something there end and just not told us.

Thanks.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-18 : 07:56:52
Are you on SQL 2000 or SQL 2005? If you are on SQL 2000 take a look at this page: http://support.microsoft.com/kb/815008

In either case, if at all possible, removing the NOLOCK hint on the query would be the first thing I would try.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-18 : 08:17:10
do you have any sql statements running with NOLOCK. As well as user queries , look at VIEWS - where you may see a select statement with NOLOCK.?



Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

JenniferK
Starting Member

2 Posts

Posted - 2013-02-18 : 09:08:47
We do not have the access to look at these items, it is our content management system trying to publish to a database that we do not have the access to look at or run queries on.
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-18 : 09:40:49
Without being able to look at the database and the queries that go into the database, there is no way that I know to fix the problem. If it is a vendor database, the best route would be to contact them. If it is an in-house database, the person(s) responsible for the database should be involved.
Go to Top of Page
   

- Advertisement -