I have a database on SQL Server 2008 R2.
I want to attach it on a SQL Server Express 2008 instance running on Windows 2003.
I set the SQL server compatibility level on the database to SQL Server 2005 in SQL Server 2008 R2 Management Studio before detaching.
But I can't attach this database to my SQL 2008 instance running on Windows 2003 due to a "compatibility error".
How can I get around this?