Noman Salim (12/14/2007)
Karthik (12/14/2007)
[font="Verdana"]Right click on the database in SSMS. Go to Tasks->Generate Scripts.Go with the defaults in the wizard till you come to the page to select object types. Select Stored Procedures. In the next screen, select Script to File -> File Per Object.
Hopefully this is what you needed![/font]
SWEET! This is exactly what I was looking for. My only problem was that I was trying it from my client machine and I couldn't find the 'File per Object' option. Then I logged into the DB server and there it was...
Muchas Gracias Senor!:w00t:
This option was added with SP2 if I remember correctly. Most likely SP2 has been installed on the server but the client tools on your machine aren't updated. Run the service pack opn your client and you should have this option there too.
[font="Verdana"]Markus Bohse[/font]