Friday, February 17, 2012

Error SQL server when try to select or delete or add new

when i try to get data or insert new from some table.

SQL show this message error

Server: Msg 3624, Level 20, State 1, Line 1
Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 52
Process ID: 2116

Connection Broken
-

how to fix this problem ? These table have around 2,900,000 records.

thanks.

Unfortunately, that seems like some form of data corruption. Try running DBCC CHECKDB and DBCC CHECKTABLE to see if you can locate the inconsistency errors. It may be that you'll have to perform a restore from a backup or perhaps a REPAIR_REBUILD will solve the problem.


Check Books Online for further information on the commands.

HTH!

No comments:

Post a Comment