none
SQL audit alter and drop table

    Question

  • Hi,

    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.

    Thanks. Regards, Rudi
    Friday, March 18, 2011 7:26 AM

Answers