• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 427
  • Last Modified:

Replicate Encrypted Stored Procedures

I have several databases that have encrypted stored procedures.  I am using snap shot replication for those databases but everything but the encrypted stored procedures can be published.  Is there a type of replication or any way to replicate encrypted stored procedures?
0
bnussbaum
Asked:
bnussbaum
2 Solutions
 
Aaron ShiloChief Database ArchitectCommented:
hi

You can't publish encrypted objects. You will need to decrypt the stored procedure and publisher the unencrypted version.

--------------------------------------------------------------------------------
0
 
devlab2012Commented:
You cannot publish the encrypted stored procedures. See the documentation at MSDN:

http://msdn.microsoft.com/en-us/library/ms187926.aspx

It states that:

ENCRYPTION
Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output of the obfuscation is not directly visible in any of the catalog views in SQL Server. Users who have no access to system tables or database files cannot retrieve the obfuscated text. However, the text will be available to privileged users who can either access system tables over the DAC port or directly access database files. Also, users who can attach a debugger to the server process can retrieve the decrypted procedure from memory at runtime. For more information about accessing system metadata, see Metadata Visibility Configuration.

This option is not valid for CLR procedures.

Procedures created with this option cannot be published as part of SQL Server replication.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now