Some useful undocumented SQL Server 2016 extended stored procedures In this article, you can find the description of some useful undocumented SQL Server 2016 extended stored procedures. xp_enum_oledb_providers This extended stored procedure can be used to get the list of all available OLE DB providers. It returns Provider Name, Parse Name and Provider Description. Syntax: EXECUTE xp_enum_oledb_providers To get a...
Tag: xp_enum_oledb_providers
Undocumented SQL Server 2014 extended stored procedures (Part 2)
Undocumented SQL Server 2014 extended stored procedures (Part 2) In this article, you can find the description of some useful undocumented SQL Server 2014 extended stored procedures. xp_enum_oledb_providers This extended stored procedure can be used to get the list of all available OLE DB providers. It returns Provider Name, Parse Name and Provider Description. Syntax: EXECUTE xp_enum_oledb_providers To get a […]