Dump SQL Server Stored Procedures to Files
- by Jake Wharton
Is there a non-interactive (read: script-able) way to dump all stored procedures to disk?
We keep versions of our stored procedures in the repository to track changes and for deployment and rollback purposes. Currently whenever we want to modify a stored procedure you have to pull it out of the DB directly when you begin your change.