Export SPs?

I have uses DTS Import/Export wizard to export all my tables from one
databse to another on the same server. How do I export all of my stored
procedures and UDFs?
Thanks,
lq1. use the DTS Wizard and specify the "Copy Objects and Data between
SQL Server databases and then select the stored procedures you want to
export.

2. Script up a file by (right) clicking on the appropiate database or
the individual procedure and Select "Generate SQL Script"

HTH, Jens Suessmeyer.|||Jens, Thanks. I didn't see that option for some reason.
This has made recovery much simpler.
lq

Export SPs?

I have uses DTS Import/Export wizard to export all my tables from one
databse to another on the same server. How do I export all of my stored
procedures and UDFs?
Thanks,
lqlaurenq uantrell (laurenquantrell@.hotmail.com) writes:
> I have uses DTS Import/Export wizard to export all my tables from one
> databse to another on the same server. How do I export all of my stored
> procedures and UDFs?

You keep your code under version control, and install them from them
from that source. What's in the database, should be regarded as binaries
in my opinion.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland,
I would love to be in the position to do it that way, but in this case,
it's an inherited mess with stored procedures supporting literally a
dozen different upgrade versions and a couple of platforms as well!|||Erland,
I would love to be in the position to do it that way, but in this case,
it's an inherited mess with stored procedures supporting literally a
dozen different upgrade versions and a couple of platforms as well!