Tag: xp_regdeletekey

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

Undocumented SQL Server 2012 extended stored procedures (Part 2)

by

Undocumented SQL Server 2012 extended stored procedures (Part 2) An extended stored procedure (xp) 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...

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 →