SQL Server Performance Forum – Threads Archive

Replication problem in SQL 7.0

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.

try running sp_removedbreplication —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

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

Hi Mohammed, Can you please tell me where are these tables located. Thanks in advance

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.

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/

]]>