sp_linkedservers
To see the linked servers defined within a SQL Server instance, you simply use sp_linkedservers:
EXEC sp_linkedserversGo
The sp_linkedservers execution provides the list of all linked servers on this SQL Server:
SRV_NAME SRV_PROVIDERNAME SRV_PRODUCT SRV_DATASOURCE------------------------- ----------------------- ---------- ---------------------ACCESS_DATABASE_CUSTOMERS Microsoft.Jet.OLEDB.4.0 Access C:\SQL2012DB\CustomersPlus.mdbDATAXDESIGN-PC\SQL2012DXD02 SQLNCLI SQL Server DATAXDESIGN-PC\SQL2012DXD02DATAXDESIGN-PC\SQL2012DXD32 SQLNCLI SQL Server DATAXDESIGN-PC\SQL2012DXD32Linked ExcelSW Microsoft.Jet.OLEDB.4.0 Jet ExcelC:\ SQL2012DB\SWCustomers.xls ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
