Foreign Key Problem


Foreign Key Problem

I'm running an insert select into a new table with a foreign key check constraint and getting an error 3807 Object Spool 2 does not exist.
when I run the select part of the query it works fine.
when I take the foreign key off the table being inserted to it works fine.

I can't even run an explain on the insert query - which implies its not my data.

Has anyone come across this before or have any immediate ideas ?


Re: Foreign Key Problem

Post your query dude. After seeing that, we can comment on that.