May 22, 2006 at 8:29 pm
I receive the following error when I try to run update Statistics. It has run fine for a couple of years and now errors out each time that I run it. I hope someone can help, I do not find much on the internet about it.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 601: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data movement.
May 23, 2006 at 4:42 am
how are you updating stats?
sp_updatestats or update statistics ?
( if you're using a maint plan I suggest you code the commands in tsql )
Be aware that technically update stats needs exclusive use of the table/index for which stats are being updated, so if you're using the database update stats will cause contention.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 23, 2006 at 5:23 am
I am running this job through a maintenance plan. It has run for about 3 years without any issues. I run this under the Optimization tab, Then I check Update statistics used by the query optimizer. Does sp_updatestats do the exact same steps?
May 24, 2006 at 2:09 am
I hate maintenence plans, sysmaint.exe etc. with a passion!!!
Yup try issuing a sp_updatestats in a job step. Given a choice I always use the native dbcc / sp's in job steps for maint.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply