title: How to keep history of SQL Server stored procedure revisions
body: <p>Note: I am not asking about full version control.</p>
  
  <p>Is there any way automatically to keep a history of stored procedures on SQL Server.</p>
  
  <p>Similar to how Google Docs automatically keeps a history of versions of documents and Wikipedia automatically keeps a history of versions of articles.</p>
  
  <p>I don't want users updating stored procedures to have also to maintain a repository of stored procedures. This is too much work and people won't do it.</p>
  
  <p>Hopefully this is something I can turn on in SQL Server...</p>
  
  <p>(And by stored procedures really I mean functions, triggers, etc. Basically everything under Programmability.)</p>