- 1). Click the Windows "Start" button and select "All Programs." Click "SQL Server 2005" from the program groups and then click "SQL Server Management Studio." This opens your main console.
- 2). Click your database server name on the left side of the window and click the "New Query" button. This opens a window where you create the query to link the server using ODBC.
- 3). Enter the following text into the query window:
EXEC sp_addlinkedserver
'OtherDatabase',
N'SQL Server'
Replace "OtherDatabase" with the name of your database server. The "N'SQL Server'" is an encoded line item that tells the SQL Server to use the SQL Server ODBC connection drivers. - 4). Press the "F5" key. This executes your command. On the left side of the window under "Linked Servers," notice your newly linked SQL Server database name.
Source...