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
Register
Already a member? Log in here