Tag: sp_linkedservers_rowset2

Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 distributed queries stored procedures

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.
Log In Register
Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 distributed queries stored procedures

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.
Log In Register