I have recently upgraded to SQL 2005 and have not found a tool for exporting
stored procedures from a source server to a destination server.  In SQL 2000
this tool was in the export feature and it seem MS has removed the copy
object tool from the export feature.

Any ideas?

I believe that this functionality is exposed in Integration Services now. It has been removed (for
some reason) from the other Import/Export wizards.

Show quoteHide quote

You can right-click on a database
Choose Tasks | Generate Scripts
Wade through the various screens
When you get to "Choose Object Types" you will want to select Stored
Procedures

Show quoteHide quote

SIMPLE command to convert string to number? Not CAST or CONVERT.
Cannot edit table data using Enterprise Manager
SQL Profiler - Strange data in RPC:Completed
Sql debugger
SQL Server trigger that fires only on update of certain field?
Backing up and restoring remote database to and from a local disk
Alternative to SQLClean?
SSMA problem - Server components have inconsistent versions
import data.
Copy Database Fails: .Net runtime error?