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!