Adding a Linked Server

DECLARE @Server sysname SET @Server = 'LINKED_SERVERNAME' EXEC sp_addlinkedserver @Server , @srvproduct = N'' , @provider = N'SQLOLEDB' , @datasrc = N'10.0.1.70' EXEC sp_serveroption @Server, N'data access', N'true' EXEC sp_serveroption @Server, N'rpc out', N'true' EXEC sp_serveroption @Server, N'rpc', N'true' EXEC sp_serveroption @Server, N'use remote collation', N'true' EXEC sp_serveroption @Server, N'collation name', N'null' EXEC sp_serveroption @Server, N'connect timeout', 0 EXEC sp_serveroption @Server, N'query timeout', 0 EXEC sp_addlinkedsrvlogin @Server, 'false', null, 'username', 'password'