I have the SQL Server 2005 Express edition with "Mixed Mode authentication".
So I want to create a database called "ActivityLogs" where I want to DENY access for the "sa" login. I want to create another login called "AuditLogin" which should be able to access this database alone.
"ActivityLogs" should not be accessible to the "sa" login for dataaccess as well as schema access.
How can this be done?