Added Target specific extended properties to Replication Subscriber Tabled

  • I have documentation in the form of extended properties for tables which are subscribers in a replication scheme. The documentation describes the tables in reference to their replication scheme. I don't want to apply them to the source and have them published.

    I can't apply the extended properties receiving the error, 'don't have permission' yet I am DB creator on all systems. The theory is that I can't modify the subscription. Which makes sense.

    Can I turn off the replication, apply the extended properties, then turn on replication without causing harm?

    John

    SQL 2012 Standard VPS Windows 2012 Server Standard

Viewing 0 posts

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