• 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