Article ID: 216575 - View products that this article applies to.
This article was previously published under Q216575
This article has been archived. It is offered "as is" and will no longer be updated.
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: