Do you want to get the Linked Servers Providers list of our DB using a single Query?

Easy to do:

create table #OLEDBProv ( Name sysname NOT NULL, ParseName sysname NOT

                  NULL,Description sysname NOT NULL ) insert #OLEDBProv EXECUTE master.dbo.xp_enum_oledb_providers

SELECT

'Server[@Name=' + quotename(CAST(

        serverproperty(N'Servername')

       AS sysname),'''') + ']' + '/OLEDBProvider[@Name=' + quotename(op.Name,'''') + ']' AS [Urn],

op.Name AS [Name]

FROM

#OLEDBProv op

ORDER BY

[Name] ASC

 drop table #OLEDBProv

The result of this query will give us the list of Linked Servers->Providers