How To Handle The Schema Or Stored Procedure Change Logs In A Table?

In SQL :- How to handle the schema or stored procedure change logs in a table? Whenever there some changes applied on the stored procedure, that change has to be store in a table.

Solution 1:

You can use DDL Triggers for this. See the list of DDL Events here.

Aaron Bertrand has blogged about this, and has provided some useful scripts.