Answer:
When 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.
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.
| Previous Question | Next Question |
| Explain what is the difference between UNION and UNION ALL? | Explain what is use of DBCC Commands? |