Microsoft SQL Server Error: 948

Version 655 refers to SQL2008, version 611 refers to the SQL2005, (there is also a version 539 refers to the SQL2000) the landlord's situation is typical from a high version to lower version of the use of the scenario. According to Microsoft's official statement, is not supported from the high version attached to the lower version. What if we must do this? There's a way. First, find a computer with SQL Server 2008 and attach your database file to this computer. After the attachment succeeds, in the SSMs Object Explorer window, right-click the database you just attached, select Task > Build Script ..., and the Script Wizard dialog box appears. Click "Next". In the Select Database dialog box, select the database you just attached, and tick the bottom "script all objects in the selected database". Click Next. In the Select Script Options dialog box, you also need to modify the following several options:

1). " The script that writes the data ", set to" True "; (SQL2005 does not have this option, so to find a computer equipped with SQL2008, how easy Ah, save the data import and export trouble)

2). " Write trigger Script ", set to" True ";

3). " Write the script to create the database ", set to" True ";

4). " Script The server version ", select SQL Server 2005;(If it is the SQL2000 you want to use, then choose SQL Server 2000) above 4 options are very recommended to do so, the other options on their own to do, others generally do not have to change. Click Next. In the Output Options dialog box, select Save script to file, other default, point to next. Click Finish. Click Close.

Then copy the script file you just generated to your own computer and open and execute the script in SQL Server 2005.!!! Note: Before you execute the script, be sure to modify the script if necessary

Specify the physical path of the MDF file and the LDF file to match your own requirements.

Microsoft SQL Server Error: 948