Deadlock generating publications | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Deadlock generating publications

Hi, I have a condition where I am elected deadlock victim while I am trying to add a subscriber during replication. Other people are investigating the system, but what I tasked with doing is clearing out the tables to rerun it. The dead lock always occurs when the proc sp_addpublication_agent is run right after sp_addpublication runs successfully. I’ve downloaded systbl.chm and have found parts of the transactions syspublications, sysarticles, syssubscriptions (with references to sysobjects and sysservers) but when I try to re-add the subscriber I get the message I am already added and when I try to delete the subscriber it says that it does not exist. Is there any procedure that just cleans out a subscriber? -Thanks -Pat
May check sp_dropsubscriber from books online.
REFer to books online for this behaviour. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>