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.
| Author |
Topic |
|
harringj
Starting Member
1 Post |
 Posted - 2013-09-25 : 08:35:00
|
| I am trying to setup database auditing on our SQL2008 server. I have setup a server level audit and it appears to be working ok. I want to audit (insert/update/delete) for a specific set of users but if I put anything except "Public" in the principle name field it doesn't create an entry in the audit log. Can anyone help with what I've missed in the setup. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-09-26 : 09:35:04
|
| One alternate would be create a trigger for DML actions and then log the results to a custom table.mohammad.javeed.ahmed@gmail.com |
 |
|
|
|
|
|
Database auditing