Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jaide smith
Starting Member
1 Post |
 Posted - 2013-01-19 : 07:36:01
|
| If select SQL linked server in the GUI you can't specify a different name for the SQL Server. You can only use the SQL host name as the Link Server name. Here is an example of creating a Linked Server via script to specify link server name myGX620 for the SQL Server host name GX620. /****** Object: LinkedServer [myGX620] Script Date: 04/07/2009 22:49:10 ******/EXEC master.dbo.sp_addlinkedserver @server = N'myGX620', @srvproduct=N'MSSQL', @provider=N'SQLNCLI', @provstr=N'PROVIDER=SQLOLEDB;SERVER=GX620' EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'myGX620', @useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='P@ssword!'Internet Marketing Auckland | Web Design Auckland |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-06 : 00:12:56
|
| Hi Smith,What is expected from users related to link server? You have provided solution related to link server. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
How to create a SQL Server link server