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.Have you checked Linked Servers?
--
Jack Vamvas
___________________________________
Need an IT job? http://www.itjobfeed.com
"Josef Meierhofer" <jmeierhofer@.gmx.comwrote in message
news:hga623l6c1v4fbghk7rbmp7omuaplp6tn0@.4ax.com...
Quote:
Originally Posted by
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.
>
>
Quote:
Originally Posted by
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, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
