Prev: Deferred updates
Next: How to replication in MSSQL 2005 on local network ?
From: LN on 29 Jan 2010 15:11
Hi,

I am new to replication and after setting up trans replication, I add the
table below at publisher and want to synch to subscriber only this table not
entire snapshot again. Any help would greatly appreciate. BTW, I am using
SQL 2005.

EXECute sp_addarticle @publication = 'Rep_MyDB_Trans'
, @article = 'employee'
, @source_table = 'employee';
go

Thanks.
From: Paul Ibison on 29 Jan 2010 15:16
You'll need to run sp_addsubscription. After that run the snapshot agent and
the distribution agent.
HTH,
Paul Ibison

From: NMahmoud on 30 Jan 2010 12:52
you can use sp_reinitsubscription for one article

EXEC sp_reinitsubscription
@publication = 'Rep_MyDB_Trans'
, @article = 'employee'
,@subscriber = All -- or set to a certain subscriber


"LN" <LN(a)discussions.microsoft.com> wrote in message
news:72EB0262-10B7-4BB0-9AE1-0928F94687BA(a)microsoft.com...
> Hi,
>
> I am new to replication and after setting up trans replication, I add the
> table below at publisher and want to synch to subscriber only this table
> not
> entire snapshot again. Any help would greatly appreciate. BTW, I am
> using
> SQL 2005.
>
> EXECute sp_addarticle @publication = 'Rep_MyDB_Trans'
> , @article = 'employee'
> , @source_table = 'employee';
> go
>
> Thanks.


 | 
Pages: 1
Prev: Deferred updates
Next: How to replication in MSSQL 2005 on local network ?