Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-27 : 09:36:43
|
| Curtis writes "I was trying to create a 2nd pull subscription on the the target server after creating the publications on the source machines. The 1st pull subscription created normally.I got the following error:"SQL Server Enterprise Manager could not create a pull subscription to publication 'SPC_Sumter_Merge'.""Error 14058: The subscription already exists."How do I get around this problem??Thanks,Curtis" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-27 : 13:08:37
|
| I've seen this happen when you restored a database with a subscription defined over top of one that didn't previously have a subscription. I've worked around the issue by either modifying the system tables that govern replication or by disabling and then re-enabling (and reconfiguring) replication on the subscriber side.Jonathan Boott, MCDBA |
 |
|
|
|
|
|
Error 14058