I have the following sql server data access questions:
1. I would like users to sign on to sql server using group roles by using sql authenication. However, I would like sql server to know who the individual users are are so I can keep an audit trail of changes made to the various database tables. Can you tell me if this is possibly and point me to a reference I can use to see how to code this request?
2. Can sql server 2008 use the active directory? If so, can you point me to a reference that shows how to accomplish this task?