I was just working on some db code and realized I couldn't use TRY_CONVERT, because despite the fact that we are on SQL Server 2012, the impresario database compatibility level is set to 2008 (100 instead of 110).
Presuming this is the proper configuration for Tessi v.12, could someone shed some light on the thinking behind it? Like, version 12 "supports SQL Server 2012", and v.14 (or is it 15) will require it, but I would have expected the db compatibility level to track the newest supported server version.
Or maybe it's that compatibility level tracks the oldest supported server version? Would it be highly anti-recommended to try to run tessitura v.12 on a database with compatibility level set to 110?
Thanks
I would like to know the answer to this one as well...
Thanks,David
FYI, In reply to a recent support ticket I learned:
'According to Chuck "SQL Server 2012 is compatible with v11 and all releases of v12 running in SQL 2012 compatibility mode."'