Note. I am not asking for complete version control.
Is it possible to automatically save the history of stored procedures on SQL Server.
Just like Google Docs automatically saves version history of documents, and Wikipedia automatically saves version history of articles.
I do not want users updating the stored procedures to also be able to store the stored procedure repository. This is too much work, and people will not do it.
Hope this is what I can enable in SQL Server ...
(And by stored procedures, I really mean functions, triggers, etc. Basically, everything is under Programmability.)
source
share