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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Unable to Replicate View or function because

Author  Topic 

sandeepsingh005
Starting Member

1 Post

Posted - 2009-05-15 : 02:08:31
Hi ,

I ma having an issue in replication, the sbscription fails wuith ethe message -
Unable to Replicate View or function because the referenced objects or column are not present on the subscriber.

Actually it is trying to replicate a view but the table on which the view was created was added as an article to be replicated.

Now I have added it but do I need to reinitiallize the replication?

This is in the propduction system and users are logged into the application, reinitializing will lead to slowness in the application and will also take another 7 hrs.

Is there an easier method..??

Please help!

-Sandeep

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-05-15 : 04:04:02
Yes, it should just create this item (which will take as long as it takes to create and populate that table) as long as the other objects are not out of date.

Test it on your DEV/UAT environment.
Go to Top of Page
   

- Advertisement -