Post reply

How to copy crypted stored procedure?

  • November 25, 2009 at 6:26 am

    #206713

    How to copy a encrypted stored procedure from one instance to another?

    Scripting method does not work.

    Replication is also not supported for encrypted stored procedures.

    Is there any other method?

  • November 25, 2009 at 6:35 am

    #1083949

    You can't copy the encrypted stored procedure. You need to decrypt it, may be using third party, and then copy to other database.

    If you just want the copy of database on other server with stored procedure, the mirroring or DTS will not work. You need to backup and restore the database on other server.

  • November 25, 2009 at 7:08 am

    #1083980

    In case you have the original script of the procedure somewhere in VSS, just get the script and create the same here.

Viewing 3 posts - 1 through 2 (of 2 total)

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