SQL Server Performance

Deadlock generating publications

Discussion in 'Performance Tuning for SQL Server Replication' started by P2003Morris, Jul 31, 2003.

  1. P2003Morris New Member

    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
  2. satya Moderator

    May check sp_dropsubscriber from books online.
    REFer to books online for this behaviour.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page