I\'m trying to execute a distributed transaction for a single Oracle linked server using SQL Server 2000, I came up with the following script:
I have run into a strange problem using SQL Server 2000 and two linked server. For two years now our solution has run without a hitch, but suddenly yesterday a query synchronizing data from one of the
Based on the answer I receive开发者_C百科d on this question (https://stackoverflow.com/questions/1911969/...) I have set up a Linked Server on SQL Server 2008 to a Pervasive database.
I have a WebTrends ODBC source on server1 and a SQL Server 2005 on server2. I want to connect to this ODBC from SQL Server on server2. So far, I managed to connect to this ODBC from SQL Server which i
I am using MS SQL Server 2000 and have a link from a test db to a live db which is in replication. The link seems to work fine and I can select from any of the tables using any of the fields apart fro
Trying to update a table on a linked server (SQL 2000/2005) but my server name will not be known ahead of time. I\'m trying this:
We\'re looking to iron out issues in our different dev/test/prod environments. Currently we have to remember to change the name of linked servers in stored procedures when we migrate from UAT into Pr
I have 2 SQL 2005 servers SRV1 and SRV2. SRV2 is the linked server on SRV1. I run a storep proc with params on SRV2 and it is completed immediately开发者_开发问答. But when I run the same proc through
I have the following trigger, which causes an error when it runs: CREATE TRIGGER ... ON ... FOR INSERT, UPDATE
Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (B) scenario.
加载中,请稍侯......