"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:eh2BYousFHA.904@tk2msftngp13.phx.gbl...
> Roger,
> I'm not sure why you wouldn't want to add the column at the publisher
> using sp_repladdcolumn. Can you give us some more info? If this column is
> to have its values replicated, the publication must be made aware of it so
> as to update the stored procedure parameter list.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:urxuuwusFHA.1252@TK2MSFTNGP09.phx.gbl...
> you will have to manually edit the update and insert procs on the
> subscriber
> to account for these new columns.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roger Nygård" <roger@askit.no> wrote in message
> news:dfk50q$hsr$1@services.kq.no...
>> ms-SQL2000 sp4
>>
>> I want to replicate a database to a destination db using transaction
>> replication (one way)
>> This destination db (subscriber) has alredy the schema which is the same
> as
>> the source (publisher) schema
>> BUT a column is added on each table. (and I don't want to add this column
> at
>> the publisher)
>> By default this is not working in ms-replication. I got an insert failure
>> (Insert Error: Column name or number of supplied values does not match
> table
>> definition.)
>>
>>
>> Is it possible to mssql replication to work in this case?
>>
>> Roger Nygård
>>
>>
>
>

"Roger Nygård" <roger@askit.no> wrote in message
news:dfk50q$hsr$1@services.kq.no...
> ms-SQL2000 sp4
>
> I want to replicate a database to a destination db using transaction
> replication (one way)
> This destination db (subscriber) has alredy the schema which is the same
as
> the source (publisher) schema
> BUT a column is added on each table. (and I don't want to add this column
at
> the publisher)
> By default this is not working in ms-replication. I got an insert failure
> (Insert Error: Column name or number of supplied values does not match
table
> definition.)
>
>
> Is it possible to mssql replication to work in this case?
>
> Roger Nygård
>
>