Thread: restore problem

    #1
  1. Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Scotland
    Posts
    10
    Rep Power
    0

    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.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    Enterprise manager -> Select database -> Right click -> All tasks -> Generate SQL script .. -> (select "Show all" and then choose the stored procedures you want to export)
  4. #3
  5. Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Scotland
    Posts
    10
    Rep Power
    0
    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.
  6. #4
  7. Introspective
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Nov 2001
    Location
    London, UK
    Posts
    3,317
    Rep Power
    110
    moved thread to ms sql forum

IMN logo majestic logo threadwatch logo seochat tools logo