We have an Windows Server 2008 R2. On that we installed Microsoft SQL Server 2008 R2, which holds a Database Compatibility level: SQL Server 2005 (90).
We need to restrict the access rights on a table. However, only on certain rows, which have a defined indexname so that only a AD group can access those indexnames!
Is that possible and how?