|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Yesterday @ 11:13 PM
Points: 174,
Visits: 92
|
|
Following is the code in which we are getting the error.
Step 1: Created Linked Server
EXEC sp_addlinkedserver 'Reddevil','','MSDASQL',NULL,NULL,
'DRIVER={SQL Server};SERVER=190.12.34.23;UID=sa;PWD=sa;'
Step 2:
DECLARE @ip VARCHAR(25)
SET @ip = '190.12.34.23'
EXEC sp_setnetname 'RedDevil',@ip
SELECT * FROM RedDevil.DatabaseName.dbo.clients
ERROR:
You cannot set network name on server 'RedDevil' because it is not a linked SQL Server.
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Today @ 3:59 PM
Points: 1,747,
Visits: 2,495
|
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 11:13 PM
Points: 174,
Visits: 92
|
|
Thanks,
We have got another solution and we have implemented it already.
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Yesterday @ 10:06 AM
Points: 286,
Visits: 1,039
|
|
deepakkn (11/6/2009)
Thanks,
We have got another solution and we have implemented it already.
Wouldn't it be nice if you can post that solution also please? so that when someone goes through this thread, they can also see what that other solution was!
---------------------------------------------------------------------------------
Convert(DBA,me,developer) .... Error converting 'you' from developer to DBA!! Missing Experience 
|
|
|
|
