Tell me what is a Linked Server?
Submitted by: AdministratorWhen we want to query on remote database server along with the local database server then we can add the remote SQL server to local SQL server in a same group using the concept called Linked Server.
We can query on both servers using T-SQL.
We can use stored Procedure sp_addlinkedserver, sp_addlinkedsrvlogin to add new Linked Server.
By using Linked Server we can SQL statement in clean and easy way to retrieve, join and combine remote data with local data.
Submitted by: Administrator
We can query on both servers using T-SQL.
We can use stored Procedure sp_addlinkedserver, sp_addlinkedsrvlogin to add new Linked Server.
By using Linked Server we can SQL statement in clean and easy way to retrieve, join and combine remote data with local data.
Submitted by: Administrator
Read Online SQL Database Concepts Job Interview Questions And Answers
Top SQL Database Concepts Questions
☺ | Explain what are Magic tables in SQL Server? |
☺ | Do you know how to send email from database? |
☺ | How to search for a string in all stored procedure in SQL Server? |
☺ | Explain how to use Linked Server? |
☺ | Explain difference between cross join and Full outer join? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |