Tag: xp_fileexist

Pro Members SQL Server Standard Members

Useful undocumented SQL Server 2017 extended stored procedures

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Undocumented SQL Server 2014 extended stored procedures (Part 2)

by

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 […]

Continue Reading →
Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 extended stored procedures (Part 1)

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →