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 |
|
dkimbrell
Starting Member
9 Posts |
 Posted - 2012-03-12 : 21:36:13
|
| I was adding views and tables to my server's SQL Server 2008 on Friday. We are setup for merge replication. Each time after adding a view or table, and marking it as an article for replication, I created a new snapshot. At some point during the various View additions and subsequent snapshot creations, I deleted a view that I determined I no longer wanted. I created a new snapshot after this, synched with no problem, and continued my schema changes. My synchs work fine, and about 80% of the users are able to synch. But the other 20% are getting an error message during their synch that the object I deleted ("vMainOppsList") is invalid. Why would they be getting this message? Maybe they synched during the time I was doing my schema changes and their scripts got out of order?Where can I begin to look to fix this? Are the scripts somewhere I can find them and see where the replication is referencing this deleted view?I am very much a newbie and have no one I know who can help me. Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-13 : 11:42:08
|
| They're in the snapshot folder. You may need to reinitialize all subscriptions.How many subscribers? How often do they connect? |
 |
|
|
dkimbrell
Starting Member
9 Posts |
Posted - 2012-03-13 : 13:33:49
|
| I was able to recreate the missing view on the subscriber, and the the synch worked OK. Thanks |
|
|
|
|
|
|
I think I screwed up.....now users cannot synch