restore problem

Hi,

I have created a SQL 2000 test system to test accounting software. When trying to do a restore of the accounting software the restore fails because in cannot find specific stored procedures. In order for the restore to work I think I will need to copy all the stored procedures from the live system into the test system before attempting the data restore. How can I export just the stored procedures from the live system into the test system? Is this possible? Thanks.

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

Hi Pabloj,

Thanks for that. I chose all the stored procedures and the script was created successfully. How do I now import this into my test server? I tried just running the script in query analyzer on the test server but the stored procedures are not there. How do you get them into a specific db's stored procedure folder? Thanks.

moved thread to ms sql forum