SQL Server Performance

Replication problem in SQL 7.0

Discussion in 'Performance Tuning for SQL Server Replication' started by jvivek2k1, Nov 21, 2006.

  1. jvivek2k1 New Member

    Hi All,

    I have a server named A replicating to other servers. Database 'one1' is invloved in replication for server A. The Database 'one1' is renamed by someone as 'two2' with publication left in it. I have deleted the publication named one1_to_one1 found in renamed database 'two2'. The publication one1_to_one1 in the database 'two2' has got deleted, but iam not able to delete the publication one1_to_one1 from REPLICATION MONITOR's publisher, When i try to delete it the error is like 'one1_to_one1' cannot be found in TRANSPUBLICATION collection.

    Can anyone please help me out. I want to delete the publisher one1_to_one1.
  2. dineshasanka Moderator

    try running sp_removedbreplication

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. MohammedU New Member

    You may need to cleanup the from distribution..mspublications table.

    Mohammed.
  4. jvivek2k1 New Member

    Hi Mohammed,

    Can you please tell me where are these tables located.

    Thanks in advance
  5. satya Moderator

    distribution..mspublications - on distributor side

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  6. dineshasanka Moderator

    rather than try to edit system tables, better first try with sp_removedbreplication, if not you may have to remove records in system tables

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page