Cannot insert into partitioned view
From: mkelly (mkelly_at_discussions.microsoft.com)
Date: 11/02/04
- Next message: Rick Sawtell: "Re: error 823, severity 24, state2"
- Previous message: Rick Sawtell: "Re: deadlock questions"
- Next in thread: Quentin Ran: "Re: Cannot insert into partitioned view"
- Reply: Quentin Ran: "Re: Cannot insert into partitioned view"
- Messages sorted by: [ date ] [ thread ]
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?
- Next message: Rick Sawtell: "Re: error 823, severity 24, state2"
- Previous message: Rick Sawtell: "Re: deadlock questions"
- Next in thread: Quentin Ran: "Re: Cannot insert into partitioned view"
- Reply: Quentin Ran: "Re: Cannot insert into partitioned view"
- Messages sorted by: [ date ] [ thread ]