Re: Add new column to a replicated table..
From: SPG (steve.nospoo.goodsell_at_nopooblueyonder.co.nopoo.uk)
Date: 02/16/05
- Next message: LBT: "RE: Get records count from SQL cursor"
- Previous message: Wayne Snyder: "Re: deadlock search"
- In reply to: Wayne Snyder: "Re: Add new column to a replicated table.."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Feb 2005 14:03:15 GMT
Thanks for that..
I sort of half guessed that when the sp failed, but the docs are not too
clear on this..
Steve
"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:%23oEXG8CFFHA.2568@TK2MSFTNGP10.phx.gbl...
> You use sp_replAddColumn INSTEAD of using alter table add column.... the
> Sp adds the column to the table, and fixes replication... since you
> manually added the column the sp fails..... drop the column and use the SP
> only.
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "SPG" <steve.nospoo.goodsell@nopooblueyonder.co.nopoo.uk> wrote in message
> news:r9IQd.16027$8B3.14345@text.news.blueyonder.co.uk...
>> Hi,
>>
>> I need to add a column to a table that is being replicated.
>>
>> Can I just do the ALTER TABLE ADD xxxx bit then make a call out to
>> sp_replAddColumn?
>>
>> When I do so, the sp fails saying the column exists. The manual says that
>> it adds the column to the publications, but does not suggest it does the
>> physical add tot the table..
>>
>> Thanks in advance,
>>
>> SPG
>>
>
>
- Next message: LBT: "RE: Get records count from SQL cursor"
- Previous message: Wayne Snyder: "Re: deadlock search"
- In reply to: Wayne Snyder: "Re: Add new column to a replicated table.."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
