Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy stored procedures
Message
 
 
To
06/12/2004 10:15:51
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00967187
Message ID:
00967200
Views:
8
>
>I copy a database by using the Data Transformation Services, but did not copy the stored procedures.
>
>Does any body knows how to copy stored procedures betweem databases.
>

Hi Sergio,

You can use Enterprise Manager to script stored procedures and than run the scrip in the destination database from Query Analyzer.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform