Home Forums SQL Server 2005 SS2K5 Replication add article to replication without snapshotting entire DB. RE: add article to replication without snapshotting entire DB.

  • alistair - sorry for delay have responded!

    you could probably do it through the GUI but it's not an auditable process within a controlled production environment so no use to me other than testing.

    ps. this takes out an object

    --do this in the publishing database

    exec dbo.sp_dropsubscription  @publication='mypublication',@article='myobjecttodrop',

    @subscriber='MYSERVER'

    exec dbo.sp_droparticle @publication='mypublication',@article='myobjecttodrop',

    @force_invalidate_snapshot=1

    exec dbo.sp_refreshsubscriptions  'mypublication'

    go

    --

     

     

     

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/