List all the MS SQL Server Objects ->LinkedServers->Providers using SQL How to List all MS SQL Server Providers List available using SQL.
like 
 Microsoft.ACE.OLEDB.12.0
 Microsoft.Jet.OLEDB.4.0
 SQLXMLOLEDB.4.0
 SQLXMLOLEDB
 SQLOLEDB
Executing the stored procedure sp_MSset_oledb_prop without parameters will return a table of the available providers and their options:

EXEC sp_MSset_oledb_prop