Viewing 3 posts - 1 through 3 (of 3 total)
I think you don't have to worry about it as when transaction will be replicated to subscribers it will take whatever happen to the transaction as a whole default will not come...
February 9, 2007 at 1:58 am
Also At publication do this in sequence
EXEC sp_dropsubscriptions ,,,,...............
EXEC sp_droppublication ,,,,,.................
EXEC sp_replicationdboption ,,,,,,,.................... (Set to fasle)
EXEC sp_dropsubscriber
EXEC sp_dropdistributor
and you are done
Thanks
Sanjeev
February 9, 2007 at 12:14 am
Also you can use SQL Server Configuration Manager (SSCM) to do the same instead of using services directly.
thanks
sanjeev
February 9, 2007 at 12:01 am
Viewing 3 posts - 1 through 3 (of 3 total)