For many businesses, there is a requirement to log all production changes. On the high end there are enterprise level products and on the opposite end the schema changes report in SSMS. But what about in between?
There is SQL Server product offering from NetWrix that everyone should be aware of. It can monitor changes to tables, views, stored procedures, users etc.