SQL Server 2014 CTP1

Microsoft has released SQL Server 2014 CTP1 Product Guide. This product guide release represents a significant milestone for customers and partners who want to experience the extensive new value delivered by SQL Server 2014 CTP1.

Download the datasheets, white papers and technical presentations from,
http://www.microsoft.com/en-us/download/details.aspx?id=39269

This will help you evaluate Microsoft SQL Server 2014 CTP1.

How To: Lists Linked Server

The following Stored procedure will returns the list of linked servers defined in the server in which we are executing it.

sp_linkedservers

This procedure will return the following informations about the linked server

Column name	Data type	Description
SRV_NAME	sysname	Name of the linked server.
SRV_PROVIDERNAME	nvarchar(128)	Friendly name of the OLE DB provider managing access to the specified linked server.
SRV_PRODUCT	nvarchar(128)	Product name of the linked server.
SRV_DATASOURCE	nvarchar(4000)	OLE DB data source property corresponding to the specified linked server.
SRV_PROVIDERSTRING	nvarchar(4000)	OLE DB provider string property corresponding to the linked server.
SRV_LOCATION	nvarchar(4000)	OLE DB location property corresponding to the specified linked server.
SRV_CAT	sysname	OLE DB catalog property corresponding to the specified linked server.

Or... you can use following SQL Scripts to lists all linked servers

select * from master..sysservers

Hope this helps!