2005 dbase back to 2000 DB

[Protheus]

Is there a way to convert a Dbase from 2005 back to 2000 ?

 

[SQLDenis]

What is your compatability level 8 or 9?
If it's 9 make it 8 and try to detach and attach to the SQL 2000 server

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Protheus]

Well I have set teh database to SQL 2000 (8) and then detached it from SQL 2005 and installed SQL 2000 on another machine and trying to attach the data base but I am getting the folloiwng error:

Error 602:

Error: 602, Could not find row in sysindexes for database ID 7, object ID 165575628, index ID 3. Run DBCC CHECKTABLE on sysindexes..

So I thought that this is a compatibility issue as when I attach it to SQL 2005 it works fine

 

[SQLDenis]

Here is your answer

http://searchsqlserver.techtarget.com/ateQuestionNResponse/0,,sid87_cid988109_tax301536,00.html

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Protheus]

this is one pain in the ASS... :-0... tnx for the info and will see what I can do now

 

[mrdenny]

This is standard. You normally can't go backwords because of changes in the meta-data format between versions.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com