issue while I want to connect SQL server 2008 from SQL server 2005 management studio due to forward compatibility. I got solution for that by using below mentioned Steps
- Click the Windows "Start" button and select "All Programs." Click the "SQL Server 2005" program group and then click "SQL Server Management Studio" from the list of shortcuts. This opens your database console screen.
Click your 2005 database name on the left side of the window. Click the "New Query" button to open your query window.
Type the following code into your query window:
EXEC sp_addlinkedserver '2008Server','SQL Server';
Replace "2008Server" with your SQL Server 2008 server name. The "N'SQL Server'" text tells the stored procedure to use the SQL Server drivers to connect
Press the "F5" key to execute the statement and connect to the server. The new linked server name is displayed on the left of your window.
