Linked server allows operation to multiple server as one query.

learn more… | top users | synonyms

-1
votes
1answer
23 views

Querying sys.master_files over a linked server

Querying sys.master_files through a linked server, I get no results. Why? How do I work around this issue?
2
votes
1answer
65 views

Using a Linked Server to import data from Excel

I have read a lot about linked servers being bad when there are multiple hops across servers and distributed joins. What if I am just using a linked server to import data into SQL Server from an ...
0
votes
0answers
9 views

SSDT project with working linked server references

I have a VS 2013 solution with two databases. One of them is supposed to got to about 10 of production servers. The other ohne will have a linked server object for each production server and will ...
0
votes
1answer
39 views

Error converting data type nvarchar to float. Oracle Linked Server

Upon executing the following query select value, cast(value as float) float_value from OPENQUERY([ORACLESERVER], 'select 3/5 as value from table') I am getting the following error: Msg 8114, ...
4
votes
2answers
96 views

Reducing impact of SUM(DATALENGTH()) over linked server

I have a query that reports back to me how much time elapsed for records to be added. I also in this query track the size of an image that was added to the database. From what I can see it looks like ...
3
votes
1answer
23 views

Error 7399 when the Access file has a password

I'm trying to create a linked server to access an old MS Access database (.mdb file) on SQL Server 2012, but I always get the error 7399 (authentication denied). So I tested with another mdb file that ...
1
vote
0answers
17 views

SQL Server: error 7303 (architecture mismatch)

I've searched a lot, but I still didn't find out a solution. I have to create a linked server to get the data from a mdb file (MS Access). I use the SQL Server 2012 Express x64 on the Windows 8.1 x64. ...
0
votes
4answers
58 views

Synonym with same name as linked server

I have a database that is used for reporting services. This database was created by a contractor who is no longer around. Buried all throughout the database are references to a single table on a ...
2
votes
1answer
36 views

SQL Server 2012 - Disable Job On Linked Server

I have a job on server B, which is linked to server A. Is it possible to disable a job that exists on server B in the context of server A? I have tried the following command from server A and receive ...
0
votes
2answers
57 views

How can I call a remote User Defined Function?

I have SQL server which contains a link to another server(For e.g: test) I have a function in linked server(name:getvalue(@parameter)).so this function output i want to retrieve in SQL server 2012.I ...
1
vote
1answer
40 views

Which technology to synchronise SQL Server and MySQL data?

Which technology should be used if I want to move my data from SQL Server to MySQL server when data is entered to SQL Server row by row and getting feedback from MySQL server? Should it be 1. ...
3
votes
1answer
43 views

SQL Server - monitor changes on linked server

We have a local SQL Server database which we have full control over, and in this local server we are linking a remote SQL Server database, to which we have only read access (no schema changes, no ...
0
votes
0answers
44 views

Linked Server Query Failures Due To Indexes

We are trying to query a 2008R2 database (ServerA) from 2012 (ServerB) using a linked server on ServerB that has security setup to use a SYSADMIN SQL Server Login on ServerA. Example: When I run the ...
0
votes
0answers
37 views

CREDENTIAL mapped to Login to gain access to file resource for Bulk INSERT

According to BOL, this should be a fairly straight-forward solution to my problem, but unfortunately, it is not working and I have not been able to find much online about using CREDENTIAL mapping. ...
0
votes
0answers
43 views

Property error when linking SQL Servers

I'm running into an issue linking SQL servers. The servers I have are: Server A - SQL Server 2008 R2 Server B - SQL Server 2014 I can set B as a linked server on A with no problem, but setting up A ...
2
votes
0answers
43 views

SSRS - ERROR NUMBER:7357 while passing multiple value parameters using comma delimited string to stored procedure

I am working on a SSRS report to display the logins permissions in a set of databases on a specific server. the server, the logins and the databases are all parameters. NULL shows them all (logins ...
0
votes
0answers
72 views

Getting TEXT data from postgres throught linked server to MSSQL

I'm using MSSQL 2008 R2 with linked server to postgres 9.4. My problem is: when I select column with data type text it shows me only XXX first chars and adds (...) on the end. select description from ...
1
vote
0answers
28 views

Is There A Benefit To Using SSIS Packages Over Linked Servers?

We have a new head DBA, and he has decided he does not want us to use linked servers for development moving forward. In addition he would like to replace all existing code that uses linked servers to ...
3
votes
0answers
107 views

OPENQUERY and server permissions

when I run my stored procedure it is a complete success, even if I run it through exec. Running these: sp_GetServerLogins GO exec ( 'sp_GetServerLogins ') GO I get this: Needless ...
1
vote
0answers
109 views

Linked Server vs. Ad Hoc (OpenRowset / OpenDatasource) Distributed Queries

I have an application which needs to grab data from different clients' databases that reside at the client's location. So alongside their normal details such as company name, address etc, I also store ...
1
vote
0answers
142 views

How to create a Linked Server from SQL Server 2008 to DB2?

( This is an edit...the real post was really big ) I'm having problem with my SQL Server 2008 to DB2 linked server. I'm getting this error: TITLE: Microsoft SQL Server Management Studio The ...
1
vote
0answers
34 views

Linker Server data import

I have three servers, A, B, and C. Each with a individual database. A and B are linked B and C are linked All queries most be run on server B for security reasons. I have data on server C which I ...
4
votes
1answer
91 views

Microsoft SQL linked server to Oracle data not updating

I need to pull data from an Oracle database running on a remote machine and use it on my sql server instance. I need to check these tables periodically for updated or new records. I have created a ...
0
votes
0answers
34 views

SQL Server: Importing snapshot of tables from linked server

I need to import 2 tables from a linked SQL server. So far, the following code has been successful: SELECT * INTO MyTable1 FROM MyLinkedServer.MyDb.dbo.MyTable1; SELECT * INTO MyTable2 FROM ...
1
vote
1answer
110 views

How to create a dummy Linked Server in SQL Server 2012

I have a database in two different production servers. I want to keep the schemas consistent between the two. One has jobs that call stored procedures that reference a Linked Server. The other does ...
0
votes
0answers
80 views

Timeout too long on SQL Server 2012 Linked Server to MySQL

We have a statement in a SQL Server 2012 stored procedure that is an INSERT into a temp table from SELECT using OpenQuery to pull data through a Linked Server from a remotely hosted MySQL database. ...
2
votes
2answers
82 views

How can I query a remote server using a local function?

I am querying a remote server for which I only have read permissions. I set up a local server with a UDF (since I cannot create one on the remote) that I would like to utilize for the query. When I ...
0
votes
0answers
86 views

How to run stored procedure with EXECUTE AS OWNER which modifies data on a linked server?

I suppose this will be marked as duplicate but I can not understand solutions in other questions. I have 2 SQL servers: SQL A (I will call it SQL) and SQL B (I will call it SQLinked). The second SQL ...
0
votes
1answer
118 views

Using Identity Insert on a linked server

We have a database hosted in Microsoft Azure and using this database connection details I have created a linked server object in SSMS on our on-premise SQL box and I can insert into it as following ...
5
votes
1answer
214 views

SQL Server ; working around collation mismatches

Imagine the following scenario: I have two servers which are on two separate private networks. A linked server has been created, and there is a table in server A which has an updated version of the ...
2
votes
0answers
51 views

Performance Implications of Explicit Collation Conversions across Linked Servers

I locally host host databases from two vendors on two different SQL instances, but on the same network. These servers frequently communicate with each other (through joins and whatnot), so we have ...
0
votes
1answer
123 views

Transaction over linked server causing time out

When I execute this query on [RemoteServer] linked server, it works just fine: INSERT INTO [RemoteServer].[DbName].[SchemaName].[TableName] VALUES (1, 'bar'); but when puting it inside a ...
0
votes
0answers
51 views

Kerberos and Linked Server

I have been reading through past posts but I am still getting issues with 2 SQL servers connecting using a linked server when querying from a 3rd SQL server. I constantly get the error "Login failed ...
0
votes
0answers
40 views

How can I quickly detect that connectivity between two linked servers has been restored?

Two database exist on two different SQL Server instances. They are linked servers, but they cannot communicate due to network issues. Someone solves the network issues, and connectivity is restored. ...
0
votes
1answer
52 views

Best practice to recover an CRUD statement to a linked server if connection is lost

I am looking for the best practice for the following scenario. We have a CRM in our company. When an employee updates the record of a company, there is trigger that fires a stored procedure which has ...
0
votes
0answers
37 views

Oracle Linked Server on SQL partial insert

I am using OpenQuery to insert into OracleLinkedServer, inside a while loop from while ( @id <= @cnt) Begin INSERT INTO OPENQUERY ( MY_LINKED_SERVER,'SELECT COL1, ...
2
votes
1answer
224 views

Add linked server from SQL Server 11.0.5058 to SQL Server 10.50.4000 [closed]

I tried to add a linked server running on SQL Server 2008 R2 (10.50.4000) from SQL Server 2012 (11.0.5058). I keep getting this error: The linked server has been created but failed a connection ...
0
votes
1answer
145 views

How to query a server linked via ODBC

I've looked at multiple other questions about querying linked servers, but nothing has worked for my setup. Notes: I'm not using localdb at all. I just wanted to use SQLSMS for a remote cache ...
0
votes
1answer
94 views

Alternatives to Linked Servers (Allow Inline SQL with Parameters)

I am trying to find a solution to execute inline SQL with parameters against some liked server databases. From what I have found online the only proper way to query a linked server is to use ...
0
votes
0answers
58 views

Oracle Linked Server only works with Sql Login

I'm having this weird error for some time. When I login to sql server and use the linked server SELECT * FROM OPENQUERY(MEGA, 'SELECT 1 FROM DUAL') I receive this error OLE DB provider ...
1
vote
1answer
1k views

SQL Server - Linked Server - Using OPENROWSET with windows integrated security

I have seen many articles regarding OPENROWSET using integrated security (Windows Authentication), but I could not make it work for me. It is working fine using SQL Server authentication: select * ...
0
votes
1answer
300 views

SQL Server : how to disable connections to a linked server?

SQL Server Linked Server to default instance - service is disabled but connection is still possible I have a server called SWLON1 that has SQL Server 2005 and SQL Server 2008 r2 installed. The SQL ...
2
votes
2answers
1k views

List Active Directory Users

My boss sent to request me that: I want to a SQL query, that lists all domain users of a specific group. I began to search query. I found several solutions using Linked Server. EXEC ...
-1
votes
1answer
27 views

Run Sp on linked server 2008 [closed]

How could i run my sp on a linked server ? Using sql-server-2008 Exec my_sp [db-srv_name].[db-name].[dbo] Please help me i am new in sql
3
votes
2answers
3k views

SQL Server: Frequent Login timeout expired in Linked server

I am using SQL Server 2012. I have scheduled a job to run every 1 hour, with 1 step calling 1 simple Stored Procedure. The Stored Procedure migrates around 1K data from production server to our local ...
0
votes
0answers
308 views

Unable to start a nested transaction for OLE DB provider “SQLNCLI11” for linked server

I have two linked servers and want to create a store procedure that simply SELECT data from one table from the first server and INSERT the data in other table from the second server. The procedure ...
0
votes
0answers
156 views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. for linked servers

I am trying to execute a query to pull data from another server. I added the server as a linked server to the another one but I am getting the following error when I try to execute the query Login ...
0
votes
1answer
59 views

Server 2012 Linked Server From An Instance

I have 3 SQL Server 2012 Instances, 2 on SiteA on the same server SiteAServer. I have 1 on SiteB on server SiteBServer. SiteADefaultInstance, SiteASecondInstance SiteBDefaultInstance ...
0
votes
2answers
44 views

Linked Servers security context and transaction logging

I have many large logging tables that are populating with data constantly. The information is rarely or never read and I want to move them out of the database. So, the idea is to: create linked ...
0
votes
1answer
50 views

MySQL out of Memory, but Only Through MSSQL Linked Server

I am getting an error "MySQL client ran out of memory" when trying to do some simple MySQL selects or inserts from Microsoft SQL through a linked server. It was working fine for a week or so, and for ...