How to create Linked MS SQL Server in Management Studio?

Databases

Creating MS SQL Linked Server means that you can access your remote MS SQL database (on other server) like it is local. Syntax to access some data is as simple as that: [linked server name].[database name].dbo.[table name] Official Microsoft documentation is really sometimes hard to use. A lot of information but none practical example of usage. Google search also didn’t helped much on the first try. After few tries I finally found out how you can add MS SQL Linked server to your existing database server. So, you need first…read more