Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2004-09-30 : 09:51:41
|
Hey All, I've got a partitioned view that I'm working with. I'm able to INSERT INTO the view and data goes into the correct tables, except in one case.I'm getting the error message below when inserting some data from the "source" non-partitioned table.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 ran the select statement that gives me the bad set of data, and used the "find dups" concept to try to find duplicate rows, but found none. Can anyone provide me a way to troubleshoot this problem? What should I be looking for?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
Issue with Partitioned View