Tag: undocumented

SQL Server

Five undocumented SQL Server 2014 distributed queries stored procedures

by

Five undocumented SQL Server 2014 distributed queries stored procedures SQL Server 2014 supports the following five useful undocumented distributed queries stored procedures: – sp_catalogs_rowset – sp_catalogs_rowset2 – sp_catalogs_rowset_rmt – sp_linkedservers_rowset – sp_linkedservers_rowset2 sp_catalogs_rowset The sp_catalogs_rowset distributed queries stored procedure returns the database name for the specified database if the current user has access for this database. Syntax sp_catalogs_rowset [ @catalog_name […]

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 Full-Text Search Stored Procedures

by

Undocumented SQL Server 2012 Full-Text Search Stored Procedures SQL Server 2012 supports the following three undocumented full-text search system stored procedures: sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_fulltext_recycle_crawl_log The sp_fulltext_recycle_crawl_log system stored procedure is used to recycle crawl log for the given full-text catalog name. Syntax sp_fulltext_recycle_crawl_log [ @ftcat = ] ‘ftcat’ Arguments [ @ftcat = ] ‘ftcat’ Is the full-text catalog name...

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

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 →
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 →
1 2