Post reply

copying multiple store procedures across databases

  • June 3, 2010 at 8:58 pm

    #1176288

    Hi,

    In SQL Management Studio right click database-> tasks->Generate scripts. Select "Stored procedures" as Object Types and don't forget to script objects permissions under Script Options.

  • June 3, 2010 at 9:07 pm

    #1176289

    thank you.

  • June 3, 2010 at 9:44 pm

    #1176297

    You just want to copy, the SP's or any planning for replication kind of ?

    If copying alone, then as suggested generate the script file and execute it 🙂

    enjoy!!

  • June 4, 2010 at 10:15 am

    #1176618

    hi,just trying to copy the sp's.Thanks for ur response.

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply