I\'m using below statement for addling a linked server: EXEC sp_addlinkedserver @server = \'north\', @srvproduct = \'\',
EDIT 4/18: I want to thank everyone who has answered so far.As a test I have set up a new job which has just one step in it,
In SQL Server 2008 (version 10.0.4000) I have created a linked server to an Active Directory server. This query:
I need to be able to run a remote sproc and store it\'s results in a temp table so that further processing can be done against the data. I can run the below exec statement on it\'s own just fine and g
I have set up a stored procedure to update a database on my linked server CREATE procedure MyProcedure
We have an SQL Server 2008 R1 Environment. We have poorly performing queries across linked servers which are quite complex.
This question already has an answer here: SQL Server Linked Server to Microsoft Access (1 answer) Closed 2 years ago.
I have opened the Linked Server dialog to create a Linked Server so that I can import my excel file data to a SQL Server 2005 database. Which provider must I use and what other settings do I need t开发
I am using SQL Server 2008 and having a linked server to an Oracle DB. Both DBs are in my local computer using Win 7.
Here\'s the issue I\'m having. I am trying to create a stored proc that will be deployed to DEV, QA, and PROD environments. Because of the strict requirements on the deployment process, I have to make