raj acharya (1/12/2009)

---

Hi,

try below query wherever you see servername put there your server name you have to create one user with admin rights on the server which you want to link with the source server and then put that server's username and password here and try,

/****** Object: LinkedServer [servername] Script Date: 01/12/2009 18:54:45 ******/

EXEC master.dbo.sp_addlinkedserver @server = N'servername', @srvproduct=N'SQL Server'

/* For security reasons the linked server remote logins password is changed with ######## */

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'servername',@useself=N'False',@locallogin=NULL,@rmtuser=N'raj',@rmtpassword='########'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'collation compatible', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'data access', @optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'dist', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'pub', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'rpc', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'rpc out', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'sub', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'connect timeout', @optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'collation name', @optvalue=null

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'lazy schema validation', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'query timeout', @optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @server=N'INDIADEV', @optname=N'use remote collation', @optvalue=N'true'