GilaMonster (2/24/2015)
kevaburg (2/24/2015)
So I migrate a 2008R2 database to 2014 and do not alter the compatibility mode. I have in end effect a database running on a 2014 Server that emulates the 2008R2 Environment.No, you have a SQL 2014 database that in some aspects of query behavior behaves like a SQL Server 2008 database. It still allows most or all of the new 2014 features, it's still a SQL 2014 database in all aspects
Ho-hum.....it was worth a go.....
Many thanks for the quick answer.
Regards,
Kev