Skip to main content

Integration

Linked Servers​

sql
-- Add Linked Server
EXEC sp_addlinkedserver 
    @server = N'RemoteServer',
    @srvproduct = N'SQL Server';
EXEC sp_addlinkedsrvlogin
    @rmtsrvname = N'RemoteServer',
    @useself = N'False',
    @locallogin = NULL,
    @rmtuser = N'remote_username',
    @rmtpassword = N'remote_password';

Integration Services​

sql

-- Enable SSIS
EXEC sp_configure 'integration services', 1;
RECONFIGURE;

Replication Setup​

sql

-- Configure Distribution
EXEC sp_adddistributor 
    @distributor = @@SERVERNAME,
    @password = N'DistributorPassword';