Can you link only other SQL Servers or any database servers
such as Oracle?
Answer Posted / guest
We can link any server provided we have the OLE-DB provider
from Microsoft to allow a link. For Oracle we have a OLE-DB
provider for oracle that microsoft provides to add it as a
linked server to the sql server group.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Is it possible to replicate data from sql server to oracle? : sql server replication
What are acid properties of transaction?
How to run sql server 2005 books online on your local system?
What happens to a trigger with multiple affected rows?
What is the contrast amongst drop and truncate?
Why do we use stored procedures in sql server?
How to connect of datebase with sql express.?
Define self join in sql server joins?
Mention the 3 ways to get a count of the number of records in a table.
Can a cursor be updated? If yes, how you can protect which columns are updated?
What are distributed partitioned views?
How to verify a user name with sqlcmd tool?
how to use DTS package in 2000,2005,2008 in sql server
How to fine-tune reports?
How each E-R model constructs can be mapped to the relational model?