Hi,

I need to export all the stored procedures from a live SQL 2000 database and import them into a test SQL 2000 database.

I have followed the following procedure:

Enterprise manager -> Select database -> Right click -> All tasks -> Generate SQL script .. -> (select "Show all" and then choose the stored procedures you want to export)

To select all the stored procedures that I want to export. This creates A SQL script. When I run this on the test server it places the stored procedure into the master stored procedures folder. How do I get these into the actual database's stored procedure's folder? Thanks.

IF you are using Query Analyzer, you first need to select the database in the drop-down menu above the clipboard, or click on the database in the left pane.
========================================
Buh Bye!

Cheers,
Me

Thanks Stealth,

Didn't see the drop down box, duh!

The stored procedures restore worked!