Link Server In SQL Server 2005

Sometimes we would like to create distributed query across different server and database, this circumstance was called "Linked Server" Make sure you have two different server or two different Database Instance, Iam here have SQLSERVER EXPRESS 2005 and SQL SERVER 2005 STANDARD EDITION, the point that you should keep in mind is 'Linked Server was dedicated for distributed query on different Database Instance' whether that is SQLSERVER or other datasource like DB2, ACCESS or EXCEL, on this occasion  I'am going to take SQL SERVER as example. In sql server we can easily make linked server by doing these following steps.

1. You have two instance or more

   

2. Fill the parameter according to this screen cast.
   

   Here detail explanation of the above

   1. Linked Server : Type the linked server that you like to define.
   2. Server Type : specify the server type as Other Data source
   3. Provider Name : Microsoft OLE DB Provider fro SQL Server
   4. Product Name: This was optional, you can fill by empty string
   5. Datasource : This parameter consist of your Server Name and Instance Name, Iam here using ".\SQLEXPRESS"
   6. Provider String: just let it be like that
   7. Catalog : Reflect the database that you would like to access.