SQL Server can be lined to any server provided it has OLE-DB provider from Microsoft to allow a link.
E.g. Oracle has a OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL
Server group.
Friday, April 18, 2008
Can SQL Servers linked to other servers like Oracle?
Labels:
SQL Interview Questions
Subscribe to:
Post Comments (Atom)
Archives
-
▼
2008
(41)
-
►
May
(20)
- Which command using Query Analyzer will give you t...
- What is SQL server agent?
- Can a stored procedure call itself or recursive st...
- What is @@ERROR?
- What is Raiseerror?
- What is log shipping?
- What is the difference between a local and a globa...
- What command do we use to rename a db?
- What is sp_configure commands and set commands?
- What are the different types of replication? Expla...
- What are the OS services that the SQL Server insta...
- What are three SQL keywords used to change or set ...
- What does it mean to have quoted_identifier on? Wh...
- What is the STUFF function and how does it differ ...
- Using query analyzer, name 3 ways to get an accura...
- How to rebuild Master Database?
- What is the basic functions for master, msdb, mode...
- What are primary keys and foreign keys?
- What is data integrity? Explain constraints?
- What are the properties of the Relational tables?
-
▼
April
(21)
- What is De-normalization?
- How to get @@error and @@rowcount at the same time...
- What is Identity?
- What is a Scheduled Jobs or What is a Scheduled Ta...
- What is a table called, if it does not have neithe...
- What is BCP? When does it used?
- How do you load large data to the SQL server datab...
- Can we rewrite subqueries into simple select state...
- Can SQL Servers linked to other servers like Oracl...
- How to know which index a table is using?
- How to copy the tables, schema and views from one ...
- What is Self Join?
- What is Cross Join?
- Which virtual table does a trigger use?
- List few advantages of Stored Procedure.
- What is DataWarehousing?
- What is OLTP(OnLine Transaction Processing)?
- How do SQL server 2000 and XML linked? Can XML be ...
- OPENXML
- What is an execution plan? When would you use it? ...
- Global Temporary Tables
-
►
May
(20)






0 comments:
Post a Comment