At first check out that your linked server is in the list by this query select name from sys.servers If it not exists then try to add to the linked server EXEC sp_addlinkedserver @server=”SERVER_NAME” –or may be server ip address After that login to that linked server by EXEC sp_addlinkedsrvlogin ‘SERVER_NAME’ ,’false’ ,NULL ,’USER_NAME’ ,’PASSWORD’ … Read more
I think what you want to do is create a linked server as per this webarchive snapshot of msdn article from 2015 or this article from learn.microsoft.com. You would then select using a 4 part object name eg: Select * From ServerName.DbName.SchemaName.TableName
Check in sys.servers: if not exists(select * from sys.servers where name = N’myserver\devdb_1′)
In my case, the service was stopped. solution: need to turn the MSDTC service on go to Services. (START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES) Find the service called ‘Distributed Transaction Coordinator‘ and RIGHT CLICK (on it and select) > Start. make this service to run Automatically for solving this issue … Read more
This is a deficiency within SQL Server. The mere existence of an xml column on the table prevents it from participating in distributed queries (eg being queried through a linked server connection). This is mentioned in this ‘retired’ documentation. There doesn’t appear to be any mention of this in the current version’s documentation. There used … Read more
You need sp_addlinkedserver() http://msdn.microsoft.com/en-us/library/ms190479.aspx Example: exec sp_addlinkedserver @server=”test” then select * from [server].[database].[schema].[table] In your example: select * from [test].[testdb].[dbo].[table]
The format should probably be: <server>.<database>.<schema>.<table> For example: DatabaseServer1.db1.dbo.table1 Update: I know this is an old question and the answer I have is correct; however, I think any one else stumbling upon this should know a few things. Namely, when querying against a linked server in a join situation the ENTIRE table from the linked … Read more
here is a portion of a procedure I use on my system to find text…. DECLARE @Search varchar(255) SET @Search=”[10.10.100.50]” SELECT DISTINCT o.name AS Object_Name,o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id=o.object_id WHERE m.definition Like ‘%’+@Search+’%’ ORDER BY 2,1