Exforsys

Online Training

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 ...


Go Back   Exforsys > Database > SQL Server

Help Needed about Error State Help Needed about Error State

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1 (permalink)  
Old 06-13-2007, 07:03 AM
Senior Member
  
Join Date: Apr 2006
Posts: 144
caradoc is on a distinguished road
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 06-16-2007, 04:55 PM
Senior Member
  
Join Date: Apr 2006
Posts: 162
sammy is on a distinguished road
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 06-24-2007, 11:08 AM
Junior Member
  
Join Date: Jun 2007
Posts: 2
manujaidka is on a distinguished road
Can you please mention the version of sql server u r running with and when this error pops up means while performing which operation?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Tools for Efficient Process | Help to Resolve the Problem »

Thread Tools

Posting Rules
You may not post new questions
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
What Permission Needed sammy Linux 1 05-19-2007 03:33 PM
Best Option Needed cyrus SQL Server 1 05-18-2007 03:00 PM
Programmer Trainees needed @ Chennai kalareddy Freshers Jobs 0 06-10-2005 11:31 AM
Programmer Trainees needed -Simply-Logic Technologies Chennai kalareddy Freshers Jobs 0 06-02-2005 10:17 PM
Documents needed for Green Card Processing Vasu Immigration Help 1 10-11-2004 09:46 PM


All times are GMT -4. The time now is 07:51 PM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.