Tuesday, March 20, 2012

Can not attach mdf 2005 file into sqlserver 2000

hello all.
I have a database file in sqlserver 2005 mode, i set it's compatiblity to sqlserver 2000 (80) but i cant attach it in sqlserver 2000.
My host only support sqlserver 2000!

I need any help to convert or attach it!
Thank all!

Sadly to say: you can not attach a SQL2005 database to a SQL2000 instance even you set the compatiblity to sqlserver 2000 (80). I'm afraid you have create a new database with exact the same schema in SQL2000, and transfer data from the original database to the new one. You can get the scripts for creating the objects of the same schemas by right clicking the objects in Management Studio.

|||

Thank!

Sql 2005 is so bad! No server is using it now!

No comments:

Post a Comment