linked-server Questions
3
Solved
I get an error querying a remote postgresql server from my sql server 2017 Standard via a linked server
this is the query:
SELECT CAST(test AS VARCHAR(MAX)) FROM OpenQuery(xxxx,
'SELECT corpo:...
Bebebebeerine asked 20/6, 2019 at 10:1
9
I am trying to run openrowset from MS SQL Server on an Oracle server.
When i execute the following command:
select * from
OPENROWSET('OraOLEDB.Oracle','srv';'user';'pass',
'select * from table')...
Mckibben asked 24/1, 2013 at 11:14
4
Solved
I have a SQL Server instance that I've added a linked server to another SQL instance. The table I'm accessing on the linked server contains spatial types. When I try to query the table I receive an...
Esquiline asked 11/3, 2011 at 21:53
34
Solved
I can't seem to connect to my database from a site. I get this error:
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
I tried using the local IP address to connect ...
Lucielucien asked 30/3, 2012 at 14:56
6
Solved
I have a local SQL Server 2008R2. I have configured Linked Server to a remote database.
The Linked Server works great when I login to the local server using a SQL-login account with sysadmin serv...
Besiege asked 19/8, 2015 at 0:0
4
Solved
I am currently running a third-party software suite, which uses SQL Server as its database. I have a second instance of SQL Server running in a different location, and some apps that I am building ...
Chigoe asked 24/7, 2009 at 18:25
6
Solved
I have a server SourceServer I am connected to which has a linked server TargetServer.
How should an insert statement looks like (I need to reference Linked server, database, namespace, tabl...
Sixpenny asked 22/6, 2012 at 8:45
11
In SQL Server 2008 (version 10.0.4000) I have created a linked server to an Active Directory server.
This query:
select TOP 901 *
from openquery(adsisca, '
select givenName,
sn,
sAMAccountName ...
Matsumoto asked 14/4, 2011 at 9:48
9
Solved
I get this weird error on SQL Server. And I cannot find solution in older posts.
I have this procedure:
create proc _upJM_SyncAll_test
as
begin
DECLARE @SQLString nvarchar(max)
set @SQLString ...
Yowl asked 2/4, 2015 at 13:31
4
Solved
I am inserting record in a remote Sql Server using Linked server, Now I wanna get the id of inserted record. something like scope_identity() in local server.
My remote sql server is 2000 version.
...
Relief asked 18/4, 2011 at 21:15
16
Solved
While in Management Studio, I am trying to run a query/do a join between two linked servers.
Is this a correct syntax using linked db servers:
select foo.id
from databaseserver1.db1.table1 foo,
...
Mclaren asked 3/11, 2010 at 21:44
4
There are plenty of examples around showing how to use OPENROWSET and OPENDATASOURCE to open queries against tables on remote SQL servers, and to get data from files on other servers. Unfortunately...
Carisa asked 6/5, 2017 at 2:50
7
Suppose that I have a database which name is testdb in test server.
I also have a database named proddb in prod server.
Now I want to select data of a table of testdb database from proddb database....
Keener asked 6/4, 2009 at 5:25
5
i'm trying to call a User-Defined Function (UDF) on a linked server:
CREATE FUNCTION [dbo].[UserGroupMembershipNames](@UserGUID uniqueidentifier)
RETURNS VARCHAR(8000)
AS
BEGIN
RETURN ASILIVE.Re...
Tramel asked 8/11, 2010 at 16:31
4
Solved
If I want to run this sort of query in SQL Server, how can I do the same query from one server I am connected to to another?
I tried adding "[ServerName1]." before "[DatabaseName1].[dbo]..." and "...
Ectoderm asked 19/7, 2010 at 21:52
7
I am trying to query a MySQL linked server using SQL Server.
The below query runs just fine.
SELECT * FROM OPENQUERY([Linked_Server], 'SELECT * FROM Table_Name')
Is it possible to run the same ...
Concenter asked 12/8, 2015 at 14:37
2
Solved
I try to connect a PostgreSQL to SQL Server 2012 server as linked server
I found some advices on different forum and follow it. But I'm stuck with an authentication problem.
I explain:
On the SQ...
Krenn asked 1/8, 2013 at 16:11
2
Solved
I need to write a procedure to collect data from several remote servers,
I use linkedservers and OPENQUERY to gather data from servers, but sometimes I lose connection to some servers or I simply ...
Yonah asked 17/4, 2012 at 12:23
8
Solved
I have a table called MyTable on which I have defined a trigger, like so:
CREATE TRIGGER dbo.trg_Ins_MyTable
ON dbo.MyTable
FOR INSERT
AS
BEGIN
SET NOCOUNT ON;
insert SomeLinkedSrv.Catalog....
Boisvert asked 22/5, 2012 at 14:54
7
I added a linked server, which is showing in the linked server list, but when I query it, it throws an error with the db server name.
EXEC sp_helpserver
EXEC sp_addlinkedserver 'aa-db-dev01'
Sele...
Lenna asked 30/1, 2009 at 14:42
4
I have tried and tried, and can not get linked. I can connect to the server using SSMS, but can not link to it from a local server. Here is my script (replacing things in brackets with pertainent i...
Melanson asked 18/2, 2015 at 18:12
2
Having an issue getting a SQL Server linked server to Oracle working while using a tnsnames.ora file on a network share.
If I copy the tnsnames.ora file to the local server, the linked servers wo...
Peterman asked 5/9, 2019 at 0:39
3
Solved
I recently upgraded our SQL Server from 2005 to 2014 (linked server) and I am noticing that one of the stored procedures which calls the exec command to execute a stored procedure on the upgraded l...
Prefabricate asked 4/3, 2016 at 15:34
5
Solved
"Deferred prepare could not be completed" error when using local database as linked server
I created a Linked Server from my local Sql Server, as given in
http://sqlserverplanet.com/dba/local-linked-server
However when I try to execute a stored procedure in Linked Server, it throws:
D...
Battiste asked 1/3, 2013 at 12:40
3
Solved
I'm trying to work Microsoft SQL Server Management Studio 10.0.5538.0 (latest right now) with Intellisense on linked servers, for example:
SELECT Column FROM [LinkedServer].DatabaseName.dbo.Table ...
Sparklesparkler asked 7/11, 2017 at 10:16
1 Next >
© 2022 - 2025 — McMap. All rights reserved.