Unanswered: Security Features in SS2K8 available in SS2k Compatibility Mode?
Would anyone know if any of the SS2K8 security features (data encryption, audit logging, etc.) are available in when you run the database in SS2K compatibility mode?
I have an inherited SS2K COTS web app that management would like to upgrade, primarily for the enhanced security features. Unfortunately, the front-end, even though we have the source code, is complex and a full-upgrade to SS2K8 right now would probably not be possible due to time.
I have been reading the Microsoft document "SQL Server 2008 Upgrade Technical Reference Guide" (486 pages) and have not been able to determine if what I am asking is possible. If we were able to run in the SS2K compatibility mode and gain some of the enhanced security features, it would buy some time in which we could do the full transition correctly.
Any help you can provide will be greatfully appreciated!