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
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.
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:
Both my local (and remote) SQL SERVER 2005 administrators claim that \"allowing linked-servers is a security issue\" and forbid their use here.(Huh?)
I have these linked servers, A and B. Server A is running SQL Server 2008, and B is running SQL Server 2000.
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.
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.
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\'.
I want to execute the following statement through from a link开发者_高级运维ed server (openquery):
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.
加载中,请稍侯......