Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Security Features in SS2K8 in SS2k Comp Mode?

Author  Topic 

tcarnahan
Starting Member

23 Posts

Posted - 2011-08-08 : 16:43:19
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 to SS2K8, primarily for the enhanced security features. Unfortunately, the front-end, even though we have the source code, is complex, undocumented, 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!

Thanks!
   

- Advertisement -