linked-server

相关标签：javascript jquery android 多少钱 iPhone

how to make foreign key relationship on physically distributed data?

three servers server 1 is central point which links the other two servers. the other two servers have a table which has a field which should act like a foreign key[详细]

2023-01-16 14:46 分类：问答
Which are the problems in creating and dropping a linked server just for executing a remote query?

I need to retrieve some data from a remote database, it is a kind of \"updates manager\", so my application will connect to that remote server to check if there are new updates.[详细]

2023-01-15 16:21 分类：问答
SQL 2005 - Linked Server to Oracle Queries Extremely Slow

On my SQL 2005 server, I have a linked server connecting to Oracle via the OraOLEDB.Oracle provider. If I run a query through the 4 part identifier like so:[详细]

2023-01-13 00:35 分类：问答
SQL Servers: Linked-servers without linking servers?

Both my local (and remote) SQL SERVER 2005 administrators claim that \"allowing linked-servers is a security issue\" and forbid their use here.(Huh?)[详细]

2023-01-12 14:47 分类：问答
Limiting rowcount of SELECT statements, with linked servers

I have these linked servers, A and B. Server A is running SQL Server 2008, and B is running SQL Server 2000.[详细]

2023-01-12 11:00 分类：问答
Is it possible to shrink a log file on a linked server using DBCC SHRINKFILE?

I am doing a large archival of data from one DB to another DB on a linked server.I am copying from MS sql server 2000 to MS sql server 2005.[详细]

2023-01-12 04:08 分类：问答
Strange issue between sql server 2005 (32x) and sql server 2008 (64x) linked server

I have successfully created linked server between 2005 and 2008 version. We changed a table schema on 2008 and re ordered the table columns. We also did the same on 2005 server.[详细]

2023-01-11 13:56 分类：问答
help with t-sql linked server

Based on the 2 databases below: Database_A on Server_1 Database_B on Server_2 I have created a linked server to Database_B on Server_1 instance by name \'LS_B\'.[详细]

2023-01-10 18:48 分类：问答
OPENQUERY update on linked server

I want to execute the following statement through from a link开发者_高级运维ed server (openquery):[详细]

2023-01-10 07:33 分类：问答
MySQL as Linked Server on SQL Server 2008 - Data Length Mismatch

I am trying to set up a third party MySQL as a Linked Server on SQL Server 2008. When I try to access the data via a simple OpenQuery below I get an error.[详细]

2023-01-09 04:29 分类：问答