February 10, 2009 at 3:52 am
Hi Experts,
I am getting the error
Error 602: Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes
while trying to attach a database.I am able to attach the same files in SQL Server 2005. I got the files from a client who is using SQL Server 2000.
Is there any way to find which version of SQL server file i have.
February 10, 2009 at 7:19 am
run select @ @version to get the version of SQL.
More than likely you issues is that you are trying to attach a 2005 DB to a 2000 server.
ETA: Put the to @ symbols next to each other. I just could not post that with them actually together.
February 11, 2009 at 12:24 am
Thanks for the Reply Mike.
My problem is that i have an .mdf and .ldf file and since I am not able to attach that i cant check the version or anything of that files.
Is there anyway to find the SQL Server version of those files.
February 11, 2009 at 4:09 am
If you're really feeling brave, open the mdf in a hex editor and look for the version stamp in the database header page. You're on your own for figuring out where that is though (Paul Randal's blog has some posts on page structures)
Otherwise, ask the person who gave you the files
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply