This is an answer to my question using cursors. As I've read we don't like cursors as a rule but this works.

I would prefer the elegance of an Stored Procedure...

Gianluca,

You have been so helpful.

As the particular subscriber I want to "denydatawriter" to is a web subscriber in a an infrastructure i don't control this is where the risk lies.

I...

Thanks for the suggestion Gianluca. Since we corresponded last I have discovered a great deal about SQL replication. None of it good for me.

Simply the replication topologies(Merge/Transactional/Peer-to-Peer) are not compatible...

Gianluca,

I read up on log shipping having never dealt with it before and I believe the answer is no.

The replicated data is EAV structured and makes use of row filtering...

spaghettidba (4/22/2015)

---

If I understand correctly, the Reporting Services instance will be in a different place from the subscribers and the data has to be read from the subscribers. Are you...

Thanks for your interest

The Report Data will be at a SQL server 2008 R2 Subscriber.

The reason for the two publications is this -

We have a number of subscribers running...