Is there a way to avoid the following problem:

I have a database created in SQL 2000. I detatch it from the SQL 2000
instance. I attach it to a SQL 2005 instance (I can see the compatibility
mode is SQL 2000). I detatch it from the SQL 2005 instance. I try to reattach
it to a SQL 2000 instance but get the error message "Error 602: could not

You can't attach or restore a SQL 2005 database to a SQL
2000 instance. You can go the other way - from 2000 to 2005
- but lower versions can't attach or restore from higher
versions.
Compatibility level won't make a difference. The internal
structures are different between the two versions.
Compatibility level affects what features are available and
some other functionality but not the internal structures.

-Sue

On Wed, 7 Jun 2006 05:18:02 -0700, Dick
[quoted text, click to view]