Hi John,

Newbie or no, you are correct: you need those check constraints.  But if you looke further back in this thread you'll see that we've discussed that a bit already.  Friendly user mssql_rules has indicated that their view meets all those requirements for partitioned views, and that he can in fact update through them.  If the view was not set up properly, I do not think the updates would work at all, so I think they must have this set up correctly already.

If you have any other ideas, though, keep chiming in, because you never know what small thing will help somebody finally figure something out!

Chris