Pro Members, SQL Server, Standard Members

Useful Undocumented SQL Server 2016 Stored Procedures (Part 3)

Useful Undocumented SQL Server 2016 Stored Procedures (Part 3) SQL Server 2016 supports the following useful undocumented stored procedures: sp_catalogs_rowset2 sp_catalogs_rowset_rmt sp_linkedservers_rowset sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_catalogs_rowset2 The sp_catalogs_rowset2 distributed queries stored procedure returns the list of the databases the current user has access to. Syntax sp_catalogs_rowset2 Return Code Values None. Result Sets Column name Data type Description CATALOG_NAME nvarchar(128) Is…

This content is for Pro, Pro Member, Pro Member Annual – Valentine’s, Pro Member Monthly – Valentine’s, Standard, Standard Member, Standard Member Annual – Valentine’s and Standard Member Monthly – Valentine’s members only.
Log In Register
Facebooktwittergoogle_plusredditpinterestlinkedinmail

Comments are closed.