Post reply

UPDATESTATS Job

  • September 27, 2008 at 12:58 pm

    #154767

    Hi All,

    we have updatestats job on a production server.

    Today it got failed with below error :

    Msg 601, Sev 12, State 3, Line 1 : Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000]

    can any body have any idea on this ?

    Please help me in this ?

    Thanks In advance,

    Raghavender Chavva

    Thank You.

    Regards,
    Raghavender Chavva

  • September 27, 2008 at 12:58 pm

    #878088

    Its SQL Server 2005

    Thank You.

    Regards,
    Raghavender Chavva

  • September 27, 2008 at 6:25 pm

    #878108

    This might help:

    FROM BOL for 2005

    http://msdn.microsoft.com/en-us/library/bb326281(SQL.90).aspx

    The SQL Server Database Engine cannot continue executing the query because it is trying to read data that was updated or deleted by another transaction. The query is using either the NOLOCK locking hint or the READ UNCOMMITTED transaction isolation level.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • September 28, 2008 at 6:08 am

    #878145

    Please don't cross post. It just wastes people's time and fragments replies.

    No more replies to this thread please. Direct replies to:

    http://www.sqlservercentral.com/Forums/Topic577330-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply