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 |
|
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: S1000Could 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/815008In either case, if at all possible, removing the NOLOCK hint on the query would be the first thing I would try. |
 |
|
|
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 |
|
|
|
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. |
|
|
|
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. |
|
|
|
|
|
|
SQL Server Error