Unfortunately we don't audit as much as I'ld like due to how auditing is implemented in our ERP system.

We audit a few basic fields on certain transactions, but don't audit BOM changes or most other master record changes.

Consequently we rather have to guess who might have made the change based on the date and username of whoever touched the record last.

Does SQL Server have an integrated audit function built in? Something that would let you audit changes to particular fields in tables and grab date, time, userid, and before/after field content?

If not, would it be worth while to anyone other than me to have one?