Data Fetching Error

Question

Data Fetching Error

Default port

Points: 1482

July 30, 2007 at 11:17 pm

MigrationData is my production database last few days i got the error message when i execute a procedure on this database, although i have installed new service pack 4 for sql server 2000.also i have recreated a new database By script but issue is same could any one help me in this regard

Error "

Server: Msg 625, Level 20, State 3, Procedure sp_TransformAccountAverageBalances, Line 27

Cannot retrieve row from page (1:2108289) by RID because the slotid (1) is not valid.

Connection Broken "

Regadrs

Syed Naveed

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

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

Steve Jones - SSC Editor SSC Guru Points: 728164 More actions · Answer 1

Run a DBCC CHECKDB on the db and I'd also try a select * from the table (no WHERE) to see if you can read all rows. This sounds like corruption.

If it is, you need to call MS.

Also, check your system log (Windwos) for hardware errors.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Nido786 Default port Points: 1482 More actions · Answer 2

i have execute the DBCC command for db and table as well but result is same also i have execute the select query of paritcular table it was run fine still i am not able to resolve the issue plz help me .

Regards