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
How to get the number of affected rows?
wat wil hapn if we give the both read and deny read permission to user?
How do you rebuild an identity column?
Explain sql delete command?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What do you understand by a view?
What is the full form of dql?
What is the security principal at the database level that represents your session?
Write the syntax for stuff function in an sql server?
What is the bookmark lookup and rid lookup?
what is datawarehouse?
What is difference between drop truncate and delete?
Explain temporary table vs table variable by using cursor alternative?
Which autogrowth database setting is good?
What is a derived table?