adisql - Thursday, December 21, 2017 2:42 PM
Yes, it will, but it doesn't go back far. It's not a full history.
If the changes aren't in the default trace, and you don't have custom monitoring or audits, then you will not be able to tell who made these changes.
It's possible to narrow down the list of potential culprits. SQL doesn't revert changes by itself, so if the objects are an older version, either someone reverted them, or you're looking at the wrong server, and if someone did so, then they'd need permissions to modify the objects, which should eliminate most of your users. Ask the other admins and devs.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability