Cannot insert into partitioned view

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: mkelly (mkelly_at_discussions.microsoft.com)
Date: 11/02/04


Date: Tue, 2 Nov 2004 10:29:06 -0800

I'm attempting to insert data into a partitioned view, the member tables and
view adhere to all the requirements stated in BOL. However on Insert I get
an error stating:

Server: Msg 550, Level 16, State 1, Line 1
The attempted insert or update failed because the target view either
specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION
and one or more rows resulting from the operation did not qualify under the
CHECK OPTION constraint.
The statement has been terminated.

I have verified that the partitioned view does not have WITH CHECK OPTION
set, why would I receive this error?