Attach SQL 2005 db to SQL 2000

I need to attach SQL 2005 DB to SQL 2000 server.
I cannot be sure, but I think I did it before in Entreprise Manager. I also
found an answer to my question on Internet
(http://www.thescripts.com/forum/thread648521.html), which says that it can
be done with enterprise tool.
When I'm trying to do it I get an error 602. Could not find row in
sysindexes... Run DBCC CHECKTABLE...
I did it on the source server, detached db, copied and tried to attach again
and got the same error.
Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
2000.
Any advice please
vovanIf you did this before you it was most likely after one too many beers:).
You can not go backwards from 2005 to 2000 with a restore or attach. You
must export the data and import it into a schema that you created on 2000.
--
Andrew J. Kelly SQL MVP
"vovan" <v@.v.com> wrote in message
news:%23Frf9CByHHA.1212@.TK2MSFTNGP05.phx.gbl...
>I need to attach SQL 2005 DB to SQL 2000 server.
> I cannot be sure, but I think I did it before in Entreprise Manager. I
> also found an answer to my question on Internet
> (http://www.thescripts.com/forum/thread648521.html), which says that it
> can be done with enterprise tool.
> When I'm trying to do it I get an error 602. Could not find row in
> sysindexes... Run DBCC CHECKTABLE...
> I did it on the source server, detached db, copied and tried to attach
> again and got the same error.
> Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
> 2000.
> Any advice please
> vovan
>