Hi Tony,

A good English dictionary (r for replication, c for common and s for sense)
sounds like a good start point for your man.

With heartfelt apologies, I think, in looking for what you've requested, I
may have found how what you're sensibly resisting could be done. It is
apparently possible to specify transformable replications using a DTS packet
in between. I have not investigated in depth; I noticed attached constraints
on updates in the subscriber, but I'm not sure how extensive they are.
Obviously if the database can only be updated by the distributor, the user
might as well have as many extra columns as he fancies - so long as the
disks come off his budget. It does occur to me that if transformable
distribution enables the requested feature but negates any potential
benefit as well, then the makings of a power-user-friendly argument would be
there.

Charles

> -----Original Message-----
> From: Maskevich, Tony [SMTP:Tony.[Email Address Removed] Sent: Thursday, December 12, 2002 2:03 PM
> To: LazyDBA.com Discussion
> Subject: Replication Help
>
> I have a user who wants to add a column to the subscription table in a SQL
> 2000 Transactional Replication Scenario. This causes it to fail as I
> expect
> but he is a power user and I need documentation to argue my point. Can
> anyone point me to a Microsoft Q article or a web link I can use to back
> up
> my argument.
>
> Any help would really be appreciated.
>
> Tony
>
MS Sql Server LazyDBA home page