Linked Servers is a concept in SQL Server by which we can add other SQL Se

What is a Linked Server?

Question Posted / guest

Answer Posted / guest

Linked Servers is a concept in SQL Server by which we can
add other SQL Server to a Group and query both the SQL
Server dbs using T-SQL Statements.

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the phases a transaction has to undergo?

1057

What is normalization and its types?

1032

What is the stored procedure?

1009

Explain table valued parameters in sql server? Why tvp used?

1019

How to create a trigger for insert only?

1038

What is raid? : SQL Server Architecture

1175

Mention the different types of triggers?

1114

How to check status of stored procedure in sql server?

985

List the different normalization forms?

978

How to get @@error and @@rowcount at the same time?

1035

Other than truncate statement, which other command can by-pass the trigger on the tables?

1134

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1053

What is the purpose of forms?

958

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1075

Explain different backup plans?

942