• Right click Management -> Generate scripts -> select the DB then go through it.

    On the objects list it should have "Script Create" as true and "Script Data" as false by default. Select the sp/tables you want then Script it to file and execute that file on the server you want (check it first).

    Dird


    Dird