I can just run this code, copy and paste the output in a new window and I am done. Here is a pure T-SQL solution, I didn't feel like using SMO. Right click -> Script Stored Procedures As -> Drop -> New Query Editor Window. Select the stored procedures you want to script. In the summary window, double click databases.ħ. Open you favorite database in the management studio.Ģ. In SQL Server 2005 Management studio you can not script out multiple procedures with a create and drop statementġ.
0 Comments
Leave a Reply. |