Copying SP to another DB

[sagn]

Is there a way to copy a SP from one DB to another
at the command line?


I was wondering if there was some sort of
sp_ command or something that would do this?

Thanks

ds

 

[tlbroadbent]

Check out SQL-DMO and SP_OA procedures. SQL BOL has considerable information and there are several samples provided in the SQL Development tools. Check the following link as well.

Developing SQL-DMO Applications

http://msdn.microsoft.com/library/en-us/sqldmo/dmoref_con01_2yi7.asp

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.