Cacher is the code snippet organizer for pro developers

sp_addlinkedserver
@server = 'E-TicaretProductionNew' -- Name used in queries
, @provider = 'SQLNCLI' -- SQL Native Client
, @srvproduct = '' -- Cannot be null, and if 'SQL Server' then you cannot specify the datasrc
, @datasrc = 'Data Source=91.93.139.90,2866;Network Library=DBMSSOCN;Initial Catalog=E-Ticaret;User ID=sa;Password=******;' -- IP Address of the server
, @catalog = 'E-Ticaret' -- database name on the server, if required

EXEC sp_addlinkedsrvlogin
    @useself='FALSE',
    @rmtsrvname='E-TicaretProductionNew',
    @rmtuser='sa',
    @rmtpassword='*****'


OR


USE [master]
GO

/****** Object:  LinkedServer [E-TicaretProduction]    Script Date: 25.9.2013 01:26:42 ******/
EXEC master.dbo.sp_dropserver @server=N'E-TicaretProductionNew', @droplogins='droplogins'
GO

/****** Object:  LinkedServer [E-TicaretProduction]    Script Date: 25.9.2013 01:26:42 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'E-TicaretProductionNew', @srvproduct=N'sqloledb', @provider=N'SQLNCLI', @datasrc=N'91.93.139.90,2866', @catalog=N'E-Ticaret'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'E-TicaretProductionNew',@useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='******'

GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'collation compatible', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'data access', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'dist', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'pub', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'rpc', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'rpc out', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'sub', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'connect timeout', @optvalue=N'0'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'collation name', @optvalue=null
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'lazy schema validation', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'query timeout', @optvalue=N'0'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'use remote collation', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'E-TicaretProductionNew', @optname=N'remote proc transaction promotion', @optvalue=N'true'
GO