Each organization has its own coding standards and enforcement rules. It is sometime difficult for DBAs to change the code following code review, as it may affect many different layers of the application. In large organizations, many stored procedures are written and modified every day. It is smart to keep watch on all stored procedures, at frequent intervals, before code comes to final code review. Pre-code reviewing in this manner will save lots of time. I run a few scripts every day to check the status of all the stored procedures on our development server. Doing so gives me a good indication about which stored procedures are not up to coding standards.
Reference : Pinal Dave (http://blog.SQLAuthority.com)