Hello,
I am new to Linked Servers and i have a few questions that would help me understand this better.
1> I have set up a linked server from Server A to Server B.
A job is fired from server A ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20803015.html
I am having trouble with a query that accesses linked servers.
It is taking a tremendously long time to run and is return way too many results.
The query is;
select om.ordernumber, om.entr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20944074.html
Using a linked server from an MS SQL2000 server to an AS/400 database (DB/2) using IBM Client Access 5.1 not all rows are returned.
When I do a count on the query I want to use it returns 126 ro...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20983603.html
Is it possible to retrieve the amount of disk space free and total disk space on a linked server?
Maybe using the FileSystemObject?
http://www.experts-exchange.com/Database/Miscellaneous/Q_21026273.html
Zones:
DatabasesDate Answered: 07/28/2004 Grade: A Views: 0
I have all the necessary permissions to access a remote oracle database i want to use my permissions to access and copy a table from the oracle server to an sql server.
problem 1 the oracle server...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21032680.html
I created a Linked Servers called "TestLink" . I had no problems seeing the list of my tables (by double clicking on "TestLink") or using the "Select" statement to select records against the li...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21147442.html
I have a linked server name "sql0103" and another server "sql0102"
I will like to execure a store procedure from sql0101 to the linked server sql0103
Like this
exec sql0103.master.dbo.rest...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21258592.html
hi,
I am writing an app using .NET which is basically to do what an access database was previously doing. I have to validate some entries by checking if the numbers entered exist in a table. The...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21461302.html
I am setting up linked servers to communicate between two servers. On one server I have two databases. I would like the other server to have a linked server that points to each database. I seem ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21490222.html
I have a database[1] with table[1,2...]
I need to access(query) data in another database that is set up as a LINKED Server to validate data in the database[1].
How do i write a query to LIN...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22112751.html
