Hi all,
I could swear I saw something about the Impresario db needing to remain at a 90 compatability level even after you upgrade to SQL Server 2008, but of course I can't find it now. Hopefully I dreamt the whole thing because it would make me sad to not be able to use IntelliSense in SSMS 2008. Anyone else know?
Also, we have SQL Server 2008 Enterprise, but I'm inclined to upgrade to R2. Anyone heard if there are any Tessitura issues with R2 vs plain ole' 2008? And while I'm asking... anyone heard how TranScend fares in a SQL 2008 environment?
Thanks very much!
Nancy Sheleheda
Tessitura Application Administrator
The Pittsburgh Cultural Trust Consortium
Unknown said: I could swear I saw something about the Impresario db needing to remain at a 90 compatability level even after you upgrade to SQL Server 2008, but of course I can't find it now.
I could swear I saw something about the Impresario db needing to remain at a 90 compatability level even after you upgrade to SQL Server 2008, but of course I can't find it now.
You know, I have the same recollection, but can't find anything about it either. I know that Transcend, i.e. TPAU and TPAUARCHIVE dbs, must remain at 80 or 90 as per Intrix support.
Hi Nancy and Chris,
Actually, both impresario and impresario_cci dbs MUST be at a 90 comparability level: there are Tessitura (not custom ones) stored procs and db views which do not comply with SQL 2008 syntax. For instance some have the old SQL outer join operators *= and =*.
Thanks,
Simon Basyuk, DBA of Carnegie Hall
You are correct they need to remain at 90
By the way, Intellisense still works in 90 mode. And it's pretty neat.