linked-server Questions
14
Solved
I have a linkedserver that will change. Some procedures call the linked server like this: [10.10.100.50].dbo.SPROCEDURE_EXAMPLE. We have triggers also doing this kind of work. We need to find all p...
Gannes asked 23/3, 2009 at 18:23
4
I've set up a linked server between an instance on SQL 2012 and SQL 2008R2 but
I keep getting the below error when trying to execute a stored procedure on a remote server:
Msg 7201, Level 17, S...
Wolfish asked 4/4, 2016 at 15:49
3
Solved
I have two SQL Servers (running SQL Server 2008) named DATA01 and DATA02. DATA02 has a linked server definition LINK, that points at DATA01, with suitable user mapping set up. On DATA01 there is a ...
Outgeneral asked 21/1, 2013 at 15:36
6
Assume that I have a table on my local which is Local_Table and I have another server and another db and table, which is Remote_Table (table structures are the same).
Local_Table has data, Remote_...
Immigrant asked 17/9, 2012 at 11:14
2
Solved
I am trying to connect to Sphinx from SQL Server Management Studio as a Linked server. I tried the following query:
EXEC master.dbo.sp_addlinkedserver @server=N'SPHINX_SEARCH', @srvproduct=N'', @p...
Isomerous asked 31/10, 2018 at 9:45
4
If it's a regular database, i can simply use this query to get a list of all table names and their column names of the database.
use [my_database_name]
GO
SELECT sys.tables.name AS Table_Name,
...
Swiger asked 1/12, 2016 at 18:14
3
I'm working with SQL Server Express, I created a linked server to an Oracle database.
As the title indicates, I want to insert data selected from a local table into a table at the Linked Server.
...
Saladin asked 7/1, 2016 at 13:59
1
Solved
I have a Linked Server from SQL Server to my mySQL database (Windows Server using MySQL ODBC Driver 5.3). I have a unique situation where I can only get my longtext columns to return if I convert t...
Roanne asked 4/8, 2018 at 15:15
5
Solved
I want to insert some data on the local server into a remote server, and used the following sql:
select * into linkservername.mydbname.dbo.test from localdbname.dbo.test
But it throws the follow...
Railroad asked 20/1, 2011 at 8:29
4
Solved
When running a SQL statement or a stored procedure on a database, can you connect to an external database and pull data from there?
something like:
SELECT a.UserID, b.DataIWantToGet
FROM mydb.U...
Trueman asked 21/12, 2009 at 19:53
4
Solved
Is it possible create/configure MySQL for functionality like SQL Server's Linked Server?
If yes, would you please tell me how? I'm using MySQL 5.5.
Intent asked 20/3, 2011 at 19:38
3
I have to run a query from linked server (SQL Server 2008) that contains Scalar UDF (with one parameter) on that server, when I run the query I got following error
Cannot find either column "PSW_L...
Affectional asked 20/4, 2015 at 15:28
2
Solved
I have a linked server that perfectly works when executing a query. But when I place the query in a job, it fails.
Here is the setting of my linked server
Error
Janejanean asked 9/9, 2015 at 10:46
3
Solved
I need to retrieve data from a linked server using a parameter, @PickedDate for example. The query works fine if I skip @A and @B, but it always returns an error due to a missing single quote. Plea...
Esparto asked 8/5, 2015 at 17:49
2
Solved
I need to test if a table exists in a linked server, where linked server is a parameter (it has to be), that's why I'm using exec method. I tried many ways but I didn't succeed.
Declare @LinkedSer...
Convene asked 10/3, 2014 at 14:39
2
Solved
I'm trying to replicate a production environment locally and the production database uses a linked server. I've been able to create multiple instances of localdb; is it possible to create a linkeds...
Cambrai asked 22/11, 2016 at 16:34
1
So I have this cute daisy chain:
A Table in an Azure SQL Database (tblAzure)
A View to tblAzure in a local SQL Server database (vwSQL)
A linked table in Access pointing to vwSQL (tblAccess)
Alt...
Haem asked 5/1, 2017 at 14:29
5
I have a linked server setup in SQL Server to hit an Oracle database. I have a query in SQL Server that joins on the Oracle table using dot notation. I am getting a “No Data Found” error from Oracl...
Rawboned asked 7/10, 2013 at 12:57
8
Solved
I want to port data from one server's database to another server's database.
The databases are both on a different mssql 2005 server.
Replication is probably not an option since the destination dat...
Ure asked 16/9, 2008 at 8:48
6
Solved
Can anyone guide me around to linking a server to another in SQL Server 2008 R2? I am getting the following error when trying to do so in Management Studio.
The linked server has been created bu...
Waits asked 4/3, 2011 at 19:33
3
Solved
I have a view that retrieves data from/through a linked server, thus when calling the linked table through the view I will use select * from linkerserver.linkedtable. My query works and I get a tab...
Tinny asked 2/8, 2016 at 12:44
3
Solved
I'm aware that the following query will pull down the result set from a linked server:
SELECT * FROM openquery(DEVMYSQL,
'SELECT event_id, people_id, role_id, rank, last_updated FROM event_cast'...
Hengelo asked 4/3, 2013 at 10:20
6
I have the linked server set up in SQL Server 2008. But I could not run any query against the linked server.
I tried to run this simple command but it's not working
SELECT * FROM MYSERVER..AL...
Plectrum asked 16/6, 2011 at 10:48
3
Solved
Does any know how / if it is possible to view all tables/views/stored procedures that depend on a linked server in Sql Server 2008. Basically as if the context menu "View dependencies" was accessib...
Utilize asked 23/6, 2011 at 8:55
5
Solved
I have a Stored Procedure (SP) in which I pass in one value. In this SP, I am trying to create/populate a Temp Table from the result of another SP that is on a Linked/remote server. That is I am tr...
Michelson asked 19/8, 2011 at 19:22
© 2022 - 2025 — McMap. All rights reserved.