I have some data on a MSSQL Express 2008 server. I need to move to another hosting provider and right now, they have MSSQL 2000. I have tried to export the data with SQL Management Studio and it error when it gets to the local server.
When I try to create a backup on my local computer, the backup is not created. I also have SQLBackupAndFTP and back up data there. But all these backups cannot be imported into MSSQL 2000. Any ideas on how I can get the data from MSSQL Express 2008 Server to MSSQL 2000?