Accessing Remote/Archive data in union query using Linked Server

1. Create a table in  source database instance

2. Create a table in  remote/archived database instance with the same datatype as that of the source table.

3. Now we can combines the results of production and archived data result set  into  single result set that includes all the rows that belong to all queries in the union.

Creating Linked Server for Microsoft SQL Server 2008

 

Creating Linked Servers (SQL Server Database Engine)

1.       Login in to the source server  using  login user with sysadmin privilege

2.       From the Object Explorer, expand the server objects folder and right-click the linked server folder to create new linked server

           3.  Self Explanatory

       4. Self Explanatory

            5. Self Explanatory

      

          6.   Self Explanatory

          
            7. Self Explanatory

      
            8. Self Explanatory

             The configuration of Linked Server in Microsoft SQL Server 2008 is completed.