I'm looking for an easy way to track changes that are applied to Stored Procedures. At present developers at our site can modify stored procedures (as well as other objects) and we want to track when a modification is applied, and if possible also by whom. If it could be done to also trace what kind of changes were applied, that would be even better.
I've been looking into sp_trace_setevent procedures to trace object changes, but that's getting me nowhere.
Any idea's anyone ?