"ChrisR" <anonymous@discussions.microsoft.com> wrote in message
news:036601c47a7a$4290ef50$a501280a@phx.gbl...
> sql2k sp3
>
> I know this itself cant be done. But say Im replicating to
> a denormalized table via Indexed View. I now want to add a
> new coulmn to that table and have it end up on both the
> source and Publisher and the Subscriber. The only way Ive
> found is to:
>
> Add it to both tables. Include it in the Indexed View.
> Mofify the insert and update stored procs generated by
> replication. Is there a better way?
>
> TIA, ChrisR

>-----Original Message-----
>when replication generates the snapshot it uses a sync
object or a view to
>bcp the data out of. It doesn't bcp the data directly
from the underlying
>object, rather indirectly through the sync object - which
is a view.
>
>Sync objects look like this:
>
>syncobj_0x3736454643413046
>
>You are free to tell SQL Server to use an object of your
own creation to bcp
>the data from. You use the @sync_object parameter of
sp_addarticle for this.
>
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>
>"ChrisR" <anonymous@discussions.microsoft.com> wrote in
message
>news:0b4f01c47afb$db549530$a601280a@phx.gbl...
>> Thanks guys.
>>
>> Whats a Custom Sync Object?
>>
>>
>> >-----Original Message-----
>> >There are two options when you are replicating to an
>> object on the publisher
>> >to a subscriber where the schemas are different.
>> >
>> >1) replicate an indexed view
>> >2) create a custom sync object, and a creation script
>> using sp_addarticle.
>> >You need to build custom stored procedures and deploy
>> them on your
>> >Subscriber. Such a solution will allow you to add and
>> drop new columns to
>> >the table on the publisher and have them replicated to
>> the subscriber.
>> >
>> >As you have chosen the indexed view route, your steps
>> that you have outlined
>> >seem to be correct.
>> >
>> >--
>> >Hilary Cotter
>> >Looking for a book on SQL Server replication?
>> >http://www.nwsu.com/0974973602.html
>> >
>> >
>> >"ChrisR" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:036601c47a7a$4290ef50$a501280a@phx.gbl...
>> >> sql2k sp3
>> >>
>> >> I know this itself cant be done. But say Im
replicating
>> to
>> >> a denormalized table via Indexed View. I now want to
>> add a
>> >> new coulmn to that table and have it end up on both
the
>> >> source and Publisher and the Subscriber. The only way
>> Ive
>> >> found is to:
>> >>
>> >> Add it to both tables. Include it in the Indexed
View.
>> >> Mofify the insert and update stored procs generated
by
>> >> replication. Is there a better way?
>> >>
>> >> TIA, ChrisR
>> >
>> >
>> >.
>> >
>
>
>.