October 17th, 2003, 06:40 AM
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.
October 17th, 2003, 06:50 AM
Enterprise manager -> Select database -> Right click -> All tasks -> Generate SQL script .. -> (select "Show all" and then choose the stored procedures you want to export)
October 17th, 2003, 07:09 AM
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.
October 17th, 2003, 07:26 AM
moved thread to ms sql forum