Find Last Modifcation Time of Filegroup Option in SQL Server

Question

I searched almost everywhere but I couldn't find a solution. I'm looking for a way to find the last time that user change an option of a filegroup in SQL Server database. For example, the last time of changing read-only property of a specific filegroup.

Is there any way?

Thanks :)

Answer 1

Thanks for your comments, SQL Server Audit Log solved my problem.

These link about SQL Server Auditing were helpful for me: Setup SQL Server Audit: https://solutioncenter.apexsql.com/how-to-setup-and-use-sql-server-audit-feature/ https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-2017

Read SQL Server Audit Information: https://solutioncenter.apexsql.com/analyze-and-read-sql-server-audit-information/