Error after attaching a database

I am using MS SQL 2000 Server
I had attached a database (.mdf) of size of around 1GB and after attaching when i query a table using SELECT statement i am displayed around 6550 rows and then it displays an error as given below :


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:           54
Process ID:      784

Connection Broken
viswa20Asked:
Who is Participating?
 
moduloConnect With a Mentor Commented:
PAQ'd and points removed

modulo

Community Support Moderator
Experts Exchange
0
 
lozzamooreCommented:
Which front end tool are you using to run the Select statement from?
Cheers,
0
 
Dr_DatabaseCommented:
The described problem may be, that the clustered index of the table is corrupted after the failed add column attempt. A clustered index may be corrupted if all of the following conditions are met:

You tried to add a column to an existing table and in the same transaction you added a foreign key reference from the new column to a column that is a unique clustered or unique nonclustered index key on the same table.

The add column failed and the transaction was rolled back.

After the transaction failed and was rolled back, an INSERT statement to the same table may result in an error message similar to one you mentioned.

To work around this problem you can either:
Drop, and then re-create the index.
-or-
Use this statement to re-create the corrupted index:
CREATE CLUSTERED INDEX...WITH DROP_EXISTING

Hope this helps.

Regards,
Dr. Database
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Scott PletcherSenior DBACommented:
Is the database you attached the same version and release level (including Service Pack) as the 2000 server?  If it's not, problems may arise because of internal differences in the format of .MDFs.

If, for example, it's a SQL 7.0 database, a backup and restore -- rather than an sp_attach -- should work.  If you can't make a backup from the original .mdf source, you may need to install a SQL Server instance that's at the proper release level, attach the .mdf, do a backup, then restore that backup to your new 2000 instance.
0
 
moduloCommented:
Dear: Dr_Database

I've rejected your proposed answer as Experts Exchange holds an experiment to work without the answer button.

See:        http://www.experts-exchange.com/jsp/communityNews.jsp
Paragraph: Site Update for Wednesday, November 06, 2002

By this rejection the Asker will be notified by mail and hopefully he will take his responsibility to finalize the question or post an additional comment.
The Asker sees a button beside every post which says "Accept This Comment As Answer" (including rejected answers) -- so if he/she thinks yours is the best, you'll be awarded the points and the grade.

Thanks !

modulo

Community Support Moderator
Experts Exchange
0
 
CleanupPingCommented:
viswa20:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.