June 11, 2009 at 3:25 pm
Hi oh great minds!
We have an error we need help with. We are issuing a distributed query to insert data into a table that failes. each "leg" of the query works fine on its own and even when combined, but when we attempt to INSERT its resultset into a table the entire thing stalls.
Each SQL instance is running on a different server and at a different location (do not know if this is relevant)
Here is the general schema of the query:
Insert Into TableTarget (SQL 7)
Select A, B, C, D from
TableSource1 (SQL7)
Inner join TableSource2 (SQL 7)
Inner join TableSource3 (SQL 7)
Inner join TableSource4 (SQL 7)
Inner join TableSource5 (SQL 2000)
Inner join TableSource6 (SQL 2000)
Where Not Exists (Select ... (SQL 7))
Union
Select A, B, C, D from
Inner join TableSource1 (SQL 7)
Inner join TableSource2 (SQL 7)
Inner join TableSource3 (SQL 2000)
Inner join TableSource4 (SQL 2000)
Union
Select A, B, C, D from
Inner join TableSource1 (SQL 7)
Inner join TableSource2 (SQL 7)
Inner join TableSource3 (SQL 7)
Thank you for your guidance on this matter.
Alex.
June 11, 2009 at 4:59 pm
Can you let us know what is the error.
If it's a distributed query then you may need to check the remote link and also the account which remote link is setup.
June 11, 2009 at 6:05 pm
Hi,
First of all, thanks for your interes and help offer.
The error was not explicit at all. It only displayed this:
Server: Msg 11, Level 16
General Network Error, Read your documentation
and that all it was.
Again, thanks for your guidance.
Alex.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply