Tag: sp_linkedservers_rowset

Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 distributed queries stored procedures

by

Undocumented SQL Server 2017 distributed queries stored procedures SQL Server 2017 supports the following 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 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 = ] ‘catalog_name’ Arguments [ @catalog_name = ] ‘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

Useful Undocumented SQL Server 2016 Stored Procedures (Part 3)

by

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

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

Undocumented SQL Server 2012 distributed queries stored procedures

by

Undocumented SQL Server 2012 distributed queries stored procedures SQL Server 2012 supports the following useful undocumented distributed queries stored procedures: sp_catalogs_rowset sp_catalogs_rowset_rmt sp_catalogs_rowset2 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 = ] ‘catalog_name’ Arguments [ @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 →