partition view not updatable

[Zahier]

Hi Techies,

I have this funny when I update via a partitioned view.
On the base tables I right click and untick the option "enforce constraints for replication". Now when I do and update it errors with "UNION ALL view 'tm_trans_current' is not updatable because a partitioning column was not found".
But when I tick the constraints option in my base table, the update works.

Any ideas why this would happen?

 

[ESquared]

Sounds like a catch-22. There *must* be constraints so SQL server knows which rows belong to which partition. But there must NOT be constraints in order for replication to do its job.

-------------------------------------
It is better to have honor than a good reputation.
(Reputation is what other people think about you. Honor is what you know about yourself.)

 

[Zahier]

Please excuse my ignorance as Iam a newbie to SQL Server.

Are you saying that Microsoft says for partitioned views, their must be constraints for it to work? And for replication their must not be constraints on the partitioned view?

Do you have a link to these notes in Books online?

 

[Zahier]

I have been googling and find that their are known issues with partitioned views and replication. But nowhere do I find a solution or workaround for this issue. Has anyone else had similiar problems?