Exforsys
+ Reply to Thread
Results 1 to 3 of 3

Help Needed about Error State

This is a discussion on Help Needed about Error State within the SQL Server forums, part of the Database category; I received an error 644 with Severity: 21, State: 3 in my SQL server. I tried running CHECKDB and it ...

  1. #1
    caradoc is offline Senior Member Array
    Join Date
    Apr 2006
    Answers
    122

    Help Needed about Error State

    I received an error 644 with Severity: 21, State: 3 in my SQL server. I tried running CHECKDB and it resulted with 0 allocation errors and also the consistency errors resulted with 0.I am confused on this error state. Can someone give me idea what does this severity of the error denotes and how to resolve the same. Some guidelines on this would help to solve the problem.


  2. #2
    sammy is offline Senior Member Array
    Join Date
    Apr 2006
    Answers
    144
    Severity of the error mentioned by you is 21.This indicates that you must have been using a NOLOCK scan or read-uncommitted serialization mode. Only when you have made used of these you would get error 644 with severity 21 as mentioned by you. Just check on this and update me so that I can help you resolving this further.


  3. #3
    manujaidka is offline Junior Member Array
    Join Date
    Jun 2007
    Answers
    2
    Can you please mention the version of sql server u r running with and when this error pops up means while performing which operation?


    •    Sponsored Ads



Latest Article

Network Security Risk Assessment and Measurement

Read More...