Show the remote server data source for synonyms targeting linked servers in SQL Server 2005

find_synonym_remote_targets.sql

select 
	sk.name as LocalSchemaName, 
	sn.name as SynonymName, 
	sn.base_object_name as FullTargetName, 
	substring( sn.base_object_name, 2, charindex(']', sn.base_object_name) - 2) as LinkedServerName,
	sv.data_source as RemoteServerName,
	substring( 
		sn.base_object_name, 
		charindex('[', sn.base_object_name, 2) + 1, 
		charindex(
			']', 
			sn.base_object_name, 
			charindex('[', sn.base_object_name, 2)
		) - charindex('[', sn.base_object_name, 2) - 1
	) as RemoteDatabaseName
from sys.synonyms sn
inner join sys.schemas sk
	on sn.schema_id = sk.schema_id
inner join sys.servers sv
	on sv.name = substring( sn.base_object_name, 2, charindex(']', sn.base_object_name) - 2)
order by sk.name, sn.name