Script to decrypt the @schema_option for a Transactional Replication Article

Share this Post

The code below helps decrypt @schema_option settings for Transaction Replication articles. Note the meaning of binary offset may change in future builds of SQL Server. Always check Microsoft docs for most accurate listing. You’ll find scheme_options listing documented at sp_addarticle.

Code for this example now posted on https://github.com/ReplTalk/ReplScripts/blob/master/schema_option.sql

Example:


Share this Post

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.