I created server auditing specifications in SQL 2008R2 for several changes on users (password change, rights assignment) and it works fine. Now I want to create a database auditing specifications for create, alter and drop table. According to MSDN and Technet
documentation I should use as audit action type 'DATABASE_OBJECT_CHANGE_GROUP'.
After applying this specification it only logs CREATE TABLE, no ALTER or DROP TABLE commands are logged with this audit setting.
It is very strange and I can't find other articles from people with the same problem. Hopefully anyone here can help.