I have a 2005 development db that I accidently opened in an an instance of 2008. when I detached it from 2008 and reattached to 2005, i get the following error:
Attach database failed for Server 'P299PXH1'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The database 'PAR_WORK_IN_PROGRESS' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'PAR_WORK_IN_PROGRESS'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476
When I click on this link I get the following instructions: "Modify these settings to work with the version of SQL Server in which the database will be attached.
I did not do anything in 2008 but I do not know how to modify the settings so that the file can be reattached in 2005, can someone point me in the right direction?