Article ID: 216575 - View products that this article applies to.
This article was previously published under Q216575
xp_enum_oledb_providers is a new extended stored procedure that enumerates all OLE DB providers installed on a SQL Server.
The following is the syntax for xp_enum_oledb_providers:
xp_enum_oledb_providers returns three columns as follows:
This procedure can be used to find if a specific OLE DB provider is installed before setting up a SQL Server 7.0 distributed query with sp_addlinkedserver.
REFERENCESFor more details on setting up and using distributed queries using OLE DB providers, refer to the "sp_addlinkedserver", "OpenQuery", and "OpenRowset in" topics in SQL Server 7.0 Books Online.
For additional information, see the Support WebCast at the following location: