SQLServer2005 database Restore to SQLServer2000

server|sqlserver| Data | database

The database appended to the SQL2005 can no longer be appended to the 2000

If you want to revert to SQL2000, the way I'm currently using it is to generate a database script in SQL 2005,

If all data is checked: Script allobjects in the selected database

Note that when you build, you choose the script that generates the SQL 2000 version and then use this script to build the target library in 2000.

Then use the Data Import/export tool or Query Analyzer, the data from 2005 to 2000 can be.

The diagram needs to be built again!