Peter J. Boettcher — Sat, 09 Nov 2002 01:22:04 +0000

I think you have to use a union and make sure whatever connection string you're using has the right permissions in both databases. To be on the safe side try adding the owner of the objects, for example:

SELECT field1 FROM database1.dbo.table1 WHERE something IS something

UNION

SELECT field1 FROM database2.dbo.table1 WHERE something IS something

ORDER BY field1

Mark Hensler — Fri, 08 Nov 2002 17:06:41 +0000

can you copy&paste the errors? (and code)

mycoolross — Fri, 08 Nov 2002 17:04:16 +0000

Yup get an error on all of it.

Thanks

Mark Hensler — Fri, 08 Nov 2002 17:02:44 +0000

Concept sounds right. Did you try it and get an error?