|
|
|
Forum Newbie
      
Group: Forum Members
Last Login: 1/30/2008 8:39:33 AM
Posts: 1,
Visits: 4
|
|
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 ?
|
|
|
|
|
Forum Member
      
Group: Forum Members
Last Login: Yesterday @ 7:06:30 AM
Posts: 33,
Visits: 192
|
|
Post your query dude. After seeing that, we can comment on that.
Regards:
Monika
|
|
|
|