I need to find when and which user created full text catalog, and who added/modified/deleted the columns (that were full text indexed) in that full text catalog.
Sql-server – Audit full text activity
auditfull-text-searchsql serversql-server-2008-r2
Related Question
- Sql-server – Full-text search in SQL Server on multiple tables fails
- Sql-server – Reorganize full text catalog is offline or online
- Sql-server – Full-text Catalog Corruption
- Sql-server – Full Text Catalog not populating
- Sql-server – Full text index does not honour deleted words – They are still indexed
- Sql-server – the minimum privilege required to create a full text index
- Sql-server – Full-text: lots of FT_MASTER_MERGE waits in SUSPENDED state after multiple full-text indexes created (server hangs)
- Sql-server – SQL Server 2008R2 Full Text Catalog Missing Records
Best Answer
You have to use DDL event groups that can be used to run a DDL trigger or an event notification, and also the Transact-SQL statements they cover.
Refer BOL for more details on what can be tracked.
I have posted an answer here for How to get notified when a deadlock occurs using Event notification. The concept is similar and can be applied to audit Full text catalog.