How do I find the server name for a linked server?

Question

There are easier ways to get at the server names of your linked servers. You could query sys.sysservers or run EXEC sp_linkedservers to give you all the info you need on your local linked servers including the server name. 16 сент. 2015 г.

How do I find the linked server name SQL Server?

Open SQL Server Management Studio; go to Server Objects -> Linked Server. Under Linked Server node we have Providers node that already having installed provides and that mapped to SQL Server.

How do I find my local server name?

Open up SQL Server Configuration Manager (search for it in the Start menu). Click on SQL Server Services . The instance name of SQL Server is in parenthesis inline with SQL Server service. If it says MSSQLSERVER, then it's the default instance.

How do I find linked server properties?

To view or change server properties1In Object Explorer, right-click a server, and then click Properties.2In the Server Properties dialog box, click a page to view or change server information about that page. Some properties are read-only.

How do I access a linked server database?

Open SQL Server Management Studio and connect to an instance of SQL Server. In the Object Explorer, expand the node for the SQL Server database. In the Server Objects node, right-click Linked Servers and click New Linked Server. The New Linked Server dialog is displayed.

Expert · Answer