http://www.sqlservercentral.com/Content tagged T-SQL, Stored Procedures, Miscellaneous, SQL-DMO posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Ryan demonstrates how he arrived at a solution that allows you to create scripts from a stored procedure using SQL-DMO. If you get interested in DMO, we've got quite a bit of additional content here on the site to help you get going! Ryan is a new author here on the site, please take a minute to read his article, add a comment, maybe just say hello. http://www.sqlservercentral.com/articles/Miscellaneous/creatingascriptfromastoredprocedure/973/2003/05/02http://www.sqlservercentral.com/articles/Miscellaneous/creatingascriptfromastoredprocedure/973/Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze. http://www.sqlservercentral.com/articles/Administering/scriptrunner/292/2001/06/14http://www.sqlservercentral.com/articles/Administering/scriptrunner/292/