The SQL Server "linked server" feature makes it possible to execute commands, such as a SELECT statement, on a remote server.
While in Management Studio, I am trying to run a query/do a join between two linked servers. Is this …
sql-server linked-serverSuppose that I have a database which name is testdb in test server. I also have a database named proddb …
sql sql-server database linked-serverI have a linkedserver that will change. Some procedures call the linked server like this: [10.10.100.50].dbo.SPROCEDURE_EXAMPLE. We have …
sql-server stored-procedures triggers linked-serverI recently upgraded our SQL Server from 2005 to 2014 (linked server) and I am noticing that one of the stored procedures …
sql sql-server stored-procedures sql-server-2014 linked-serverI am trying to run openrowset from MS SQL Server on an Oracle server. When i execute the following command: …
sql-server oracle oledb windows-authentication linked-serveri'm trying to call a User-Defined Function (UDF) on a linked server: CREATE FUNCTION [dbo].[UserGroupMembershipNames](@UserGUID uniqueidentifier) RETURNS VARCHAR(8000) …
sql-server sql-server-2000 linked-server user-defined-functionsI get this weird error on SQL Server. And I cannot find solution in older posts. I have this procedure: …
sql-server linked-server msdtcHow can I create View on Linked Server db. For Example I have a linked server [1.2.3.4] on [5.6.7.8]. Both db servers …
sql sql-server-2005 linked-serverI have two SQL Servers (running SQL Server 2008) named DATA01 and DATA02. DATA02 has a linked server definition LINK, that …
sql-server xml linked-serverI'm aware that the following query will pull down the result set from a linked server: SELECT * FROM openquery(DEVMYSQL, …
mysql sql-server tsql odbc linked-server