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 - 2004-10-25 : 08:51:46
|
| Amanda writes "I have configured SQL 2K SP3 for merge replication with anonymous subscriptions.Regularly, when I attempt to create a subscription and after selecting the publisher the list of available publications is either completely empty or only contains some of the publications although ALL of them allow anonymous subscriptions. If the list is only partially populated it invariably shows the publications for only one of my publication databases (I have two).I have found various ways around this although none are a guaranteed solution:1. Creating a new temp publication on the publishing db I want to create the subscription to.2. Synchronising an existing subscription with the publisher3. Just waiting long enough for SQL to remember that it happens to have 20 publications and not 0 or 10Stopping and starting services has no effect at all and nor does rebooting the server.Any solutions would be very gratefully accepted with the exception of torching the server as I have it on good authority that my users wouldn't like that!" |
|
|
|
|
|
Missing publications when creating subscriptions