Tuesday, December 4, 2007

How to add Linked Server to MS SQL Server

How to add Linked Server to MS SQL Server

Step 1

User can add a linked server by using SQL Analyzer with the following command

exec sp_addlinkedserver 'JAGUAR', 'SQL Server'

This will add a linked server with the name jaguar (running on MS SQL Server) to MS SQL Server.

No comments: