Query multiple databases on SQL Server

Question

you can create a view that selects from

• several tables
• in different databases
• on different servers
• using different credentials

Can anyone point out any online examples.

Or I can do it with Linq if I cannot create a view

Answer 1

Yes, you will want to use something called a linked server:

http://www.databasejournal.com/features/mssql/article.php/3085211/Linked-Servers-on-MS-SQL-Part-1.htm

However, you need to be a database administrator to configure it.

, LINQ to SQL DataContext, .ToList() . ToArray() , LINQ. , (, 1000 LINQ).

Answer 2

/ SQL Server.

. Online:

http://msdn.microsoft.com/en-us/library/ms190381.aspx

, , " " " ":

http://msdn.microsoft.com/en-us/library/ms187956.aspx