Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Using SP_AddLinkedServer - SQL Server

RSS
Modified on Tue, Dec 16, 2008, 3:30 PM by Administrator Categorized as SQL Server
exec sp_dropserver 'GenDev'
GO

exec sp_addlinkedserver 
     @server     = '{alias}'
    ,@datasrc    = '{physical-server-name}'
    ,@srvproduct = ''
    ,@provider   = 'SQLNCLI'
GO

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.