Microsoft SQL Server Error: 948

Microsoft SQL Server Error: Version 948 refers to sql2008, version 655 refers to sql2005, and another version 611 refers to SQL2000) the landlord's situation is a typical scenario of downgrading from a higher version to a lower version. according to Microsoft's official statement, attaching a later version to a later version is not supported. what should I do if I have to do this? There is a way. first, find a computer with SQL Server 2008 installed and attach your database files to this computer. after the attachment is successful, right-click the attached database in the object Resource Manager window of SSMs, and select "task> Generate script... ", the script wizard dialog box is displayed. click "Next ". in the "select database" dialog box, select the database you just attached, and tick "write scripts for all objects in the selected Database" at the bottom. click Next. in the "select script option" dialog box, you also need to modify the following options:

1 ). "Write a data script", set it to "true"; (sql2005 does not have this option, so it is easy to find a computer with sql2008 installed, saves the trouble of importing and exporting data)

2). "Write trigger script", set to "true ";

3). "Write the database creation script", set it to "true ";

4 ). "write a script for the server version", select "SQL Server 2005"; (if you want to use SQL2000, select SQL Server 2000) we strongly recommend that you set the above four options. You can do the other options on your own. You do not need to change the other options. click Next. in the "output options" dialog box, select "Save script to file". For other options, click Next. click Finish. click Close.

Then copy the generated script file to your computer, open it in SQL Server 2005, and execute the script .!!! Note: Before executing the script, make sure to modify the script if necessary.

The physical path of the specified MDF file and LDF file to meet your requirements.