I have built a database that I need to deploy on a test server. My SQL Server is 2014. The test servers is 2008. So, of course, I get this message:
"The database 'Something' cannot be opened because it is version 782. This server supports version 663 and earlier. A downgrade path is not supported."
So, I went into my database and changed the compatibility level to 100. That did not help.
Any suggestion?