Scripting Replication

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  January 22, 2008 at 2:19 am

  #95784

  Hi,

  Does anyone know why when you generate a drop script for a publication the following is done,

  Drop Subscribers - - That's fine

  exec sp_dropsubscription @publication = N'ENTER PUBLICATION HERE'

  , @article = N'all'

  , @subscriber = N'ENTER SUBSCRIBING SERVER HERE'

  , @destination_db = N'ENTER SUBSCRIBING DATABASE HERE'

  Drop Articles

  -Why is the sp_dropsubscription re-run here

  exec sp_dropsubscription @publication = N'ENTER PUBLICATION HERE'

  , @article = N'ENTER ARTICLE HERE'

  , @subscriber = N'all'

  , @destination_db = N'all'

  exec sp_droparticle @publication = N'ENTER PUBLICATION HERE'

  , @article = N'ENTER ARTICLE HERE'

  , @force_invalidate_snapshot = 1

  Any thoughts?

  Thanks

  Graeme

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  January 22, 2008 at 2:23 am

  #770380

  Yes...I can't type very well....Scripting Replication