June 15, 2011 at 9:35 am
Hey guys,
Im running into this error and I dont know how to fix it...I have set up transactional replication before and have not had any problems...So this is new to me!
Im setting up replication on one server for a database to get replicated to another server...When going through the Set up Publication and when you choose your articles...I select all the tables and all the views...However when I click Next in the Article Issues dialog box, I get:
Tables referenced by views are required.
Microsoft SQL Server requires that all tables referenced by views and indexed views that are published be available at the Subscriber. If the referenced tables are not published as articles in this publication, they must be created at the Subscriber manually.
And then it lists all the views below the message...I am replicating every table and every view so I dont understand why its throwing this warning message...And then after I finalize the subscription, it creates it but throws errors saying it cant create the views...the tables are there but the views are not...
Whats the explanation for this and how do I fix it? Thanks
June 15, 2011 at 11:38 am
Is it possible that there are tables from other databases used in any of the views?
June 15, 2011 at 12:05 pm
About the warning message - from what I remember the warning message comes up by default when you select to replicate views or SPs (i.e. there's no checking done to see if the warning is valid or not - it just shows up when you choose to replicate views or SPs)
For the error you are facing - I'd second what Chuck mentioned. An easy way to check out if this is the issue would be to replicate only your tables and initialize your subscriber and then create one of the views manually on the subscription DB to see if it works (or if it fails - what specific error it fails with).
Or if you don't want to go through the hassle of setting up replication just script out all your tables and create another DB with these table scripts and then create one of the failing views on that DB.
Also - what is the error message are you seeing when the views are failing to get created during subscriber initialization?
June 15, 2011 at 3:04 pm
Yeah when I talked to my supervisor, he said that the views use other tables from other servers so that is what was going on...I didnt know that (new to the cmpy)...Thank you all for your help!
July 25, 2012 at 9:45 am
thanks guys found this article
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply