Useful undocumented SQL Server 2017 extended stored procedures In this article, you can find the description of some useful undocumented SQL Server 2017 extended stored procedures. xp_availablemedia This extended stored procedure returns available drives and free space in bytes on these drives. In comparison with xp_fixeddrives, the xp_availablemedia extended stored procedure returns not only the hard drives, but all available...
Tag: xp_create_subdir
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 […]
Undocumented SQL Server 2012 extended stored procedures (Part 1)
Undocumented SQL Server 2012 extended stored procedures (Part 1) An extended stored procedure is a dynamic link library that runs directly in the address space of SQL Server. You can run extended stored procedures as normal stored procedures. Extended stored procedures are used to extend the capabilities of SQL Server. You can take advantage of the many extended stored procedures...