Are you sure linked servers are being deprecated? No, I had equated Linked Servers with Remote Servers when writing the editorial yesterday. Please accept my apologies for the confusion. Linked Servers are not the same as Remote Servers, although they perform similar functions. It is not linked servers that are being deprecated. Remote Servers are being deprecated, which is something […]
Other News
04: Stored procedures, Views
Pro-Center Video Programming for IT Professionals
03: Using Like, Aggregation
Pro-Center Video Programming for IT Professionals
02: Core statements
Pro-Center Video Programming for IT Professionals
01: Key basics
Pro-Center Video Programming for IT Professionals
04: Stored procedures, Views
Pro-Center Video Programming for IT Professionals
03: Using Like, Aggregation
Pro-Center Video Programming for IT Professionals
02: Core statements
Pro-Center Video Programming for IT Professionals
01: Key basics
Pro-Center Video Programming for IT Professionals
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.
Register
Register
Already a member? Log in here