Tag: extended stored procedures

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 →
Pro Members SQL Server Standard Members

Some useful undocumented SQL Server 2016 extended stored procedures

by

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

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 1)

by

Undocumented SQL Server 2014 extended stored procedures (Part 1) In this article, you can find the description of some useful undocumented SQL Server 2014 extended stored procedures. sp_MSgetversion This extended stored procedure can be used to get the current version of Microsoft SQL Server. Syntax: EXECUTE sp_MSgetversion For example, to get the current SQL Server version, you can run: EXEC […]

Continue Reading →