SQL Server 2008 Linked Servers

Here's a quick little query for getting a look at your linked servers in SQL Server 2008

SELECT *
FROM SYS.LINKED_LOGINS L
JOIN SYS.SERVERS S
 ON S.SERVER_ID = L.SERVER_ID
ORDER BY S.PRODUCT, S.PROVIDER, S.DATA_SOURCE