If you are using SQL server, consider utilizing version control mechanisms for your triggers and stored procedures. Many times I have heard people wondering about changes to a procedure or trigger and have no way to look at the past version to confirm their suspicions (aside from going to backups). Review commercially available products, or look at developing an in-house product to integrate with your change management or version control solution.