PRINT 'SET NOCOUNT ON
GO
SELECT auth_scheme, client_net_address, local_net_address, @@SERVERNAME as [SERVERNAME], GETDATE() as [GETDATE] from sys.dm_exec_connections where session_id = @@SPID
GO'
SELECT
'
PRINT ''Linked Server : ' + name + '''
GO
SELECT TOP 1 NAME, ''[' + name + ']'' As LinkedServer From [' + name + '].master.sys.objects;
GO
'
FROM sys.servers
WHERE name <> @@SERVERNAME
AND product = 'SQL Server'