linked-server
Connect Oracle to SQL Server
I am trying to connect Oracle 9i database using SQL Management studio 2008. I tried this but it doesn\'t work[详细]
2023-02-07 03:13 分类:问答Cannot get the data of the row from the OLE DB provider 'ProviderName' for linked server 'LinkedServerName'
I am running into this issue when I try to execute this query involving Linked Server to Oracle. Find the query underneath,[详细]
2023-02-06 05:33 分类:问答error when insert into linked server
I want to insert some data on the local server into a remote server, and used the following sql: select * into linkservername.mydbname.dbo.tes开发者_运维问答t from localdbname.dbo.test[详细]
2023-02-05 11:21 分类:问答How to avoid preemptive_oledbops SQL Server 2008 with Linked Servers
We have two SQL Servers and have them set up as linked servers. There is one particular stored procedure that when run has to join tables from the linked server to it\'s 开发者_运维问答own. Often time[详细]
2023-02-03 12:08 分类:问答Can you protect linked servers from sa
We have a third-party vendor setting up software on a server.They have full access to that server and the sql-server on it with the sa account.We would like to set up a linked server so that a trigger[详细]
2023-02-02 07:39 分类:问答linked server problem at sql server while connecting to oracle dbms
I have created a linked-server definition according to the article at : http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/[详细]
2023-02-01 15:09 分类:问答Where can i find dll for linked server in SQL Server 2008?
Actually I am new to this. I am trying to create a ppt. 开发者_Python百科so for the components part for the dll there put this dll. I was surprised how to find out this thing,[详细]
2023-01-29 04:53 分类:问答Linked Server In SQL Server Express
I am developing an app where i have a local database in SQL Server Express. During work in local database, we need to execute a query on another SQL Server / live serverand its return a value and with[详细]
2023-01-25 05:56 分类:问答SQL-Server trigger update issue from over linked server
I would like to update rows over linked server. I created linked server on my local SQL-Server with this instruction.[详细]
2023-01-25 02:59 分类:问答SQL Server: How to call a user-defined function (UDF) on linked server?
i\'m trying to call a User-Defined Function (UDF) on a linked server: CREATE FUNCTION [dbo].[UserGroupMembershipNames](@UserGUID uniqueidentifier)[详细]
2023-01-24 04:53 分类:问答