Navigation

	Home Page
	Index
	All Pages

Contributor Links

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

Other Wiki Sections

Software

Using SP_AddLinkedServer - SQL Server

exec sp_dropserver 'GenDev'
GO

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