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
Explain steps of normalization?
What are the new features of sql server 2008 r2 reporting service?
What is apply operator in sql?
What is a raid and what are different types of raid configurations?
What is clustered vs nonclustered index?
Which sql server table is used to hold the stored procedure scripts?
Tell me what do we need queues in sql service broker?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What happens if an integer is too big for int date type?
How to replace null values in expressions using isnull()?
What is merge join?
What is xml datatype?
Can you use order by when defining a view?
What is spid in sql server profiler?
What are trace files?