Tuesday, 12 August 2014

Creating Linked Server with a name other than its Server name

EXEC master.dbo.sp_addlinkedserver
    @server = N'DEV',
    @srvproduct=N'MSDASQL',
    @provider=N'SQLNCLI',
    @provstr=N'DRIVER={SQL Server};SERVER=Servername\InstanceName;UID=user1;PWD=rosebud567;',
    @catalog=N'database1'

No comments:

Post a Comment