Access to different databases in different domains

[Josef Meierhofer]

Hi everybody,

there are several SQL-Server 2000 databases within a company located
on different servers in different domains. On every database you can
find the same table X.

I want to merge these tables X (UNION query) and print the result with
a Crystal Report.

Unfortunately I only have little knowledge on security, domains,
distributed applications.

Thanks for help.

[Jack Vamvas]

Have you checked Linked Servers?

--

Jack Vamvas
___________________________________
Need an IT job? http://www.itjobfeed.com

"Josef Meierhofer" <jm*********@gmx.comwrote in message
news:hg********************************@4ax.com...

Hi everybody,

there are several SQL-Server 2000 databases within a company located
on different servers in different domains. On every database you can
find the same table X.

I want to merge these tables X (UNION query) and print the result with
a Crystal Report.

Unfortunately I only have little knowledge on security, domains,
distributed applications.

Thanks for help.

[Erland Sommarskog]

Josef Meierhofer (jm*********@gmx.com) writes:

there are several SQL-Server 2000 databases within a company located
on different servers in different domains. On every database you can
find the same table X.

I want to merge these tables X (UNION query) and print the result with
a Crystal Report.

Unfortunately I only have little knowledge on security, domains,
distributed applications.

The query as such is not tricky:

SELECT ....
FROM SERVER1.db.dbo.tbl
WHERE ....
UNION ALL
SELECT ....
FROM SERVER2.db.dbo.tbl
WHERE ....
UNION ALL
...

The problem may be with setting up the linked servers. You use
sp_addlinkedserver and sp_addlinkedsrvlogin. Supposedly there is a DBA
around with whom you can discuss how to do this.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx