April 24, 2015 at 3:41 am
Hi All, We have an issue where we are trying to replicate a DB using SQL replication, the Replication Monitor reports an error:
Cannot TRUNCATE TABLE 'dbo.xxx' because it is being referenced by object 'View_xxx'.
Although I am the DBA, I do not have an inside knowledge of this particular DB. Anyone know how I can fix this?
Many thanks in advance
April 25, 2015 at 11:29 pm
When does this happen?
Is it in the initialization phase or after replication has already started transferring data?
April 27, 2015 at 4:51 am
It sounds like a view has SCHEMABINDING set. In the article properties is it set to Drop or Truncate the table at the Subscriber? Truncate should work but Drop will not if SCHEMABINDING is set up on a view. No table alterations can be made until the view is dropped.
July 26, 2016 at 8:44 am
are you saying that teverytime we wnat to do a stapshot we will have to drop and recreate the view?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply