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.
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.