Distributed Queries Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server supports the following system stored procedures that are used to implement and manage Distributed Queries.

sp_addlinkedserver sp_indexes
sp_addlinkedsrvlogin sp_linkedservers
sp_catalogs sp_primarykeys
sp_column_privileges_ex sp_serveroption
sp_columns_ex sp_table_privileges_ex
sp_droplinkedsrvlogin sp_tables_ex
sp_dropserver (Transact-SQL) sp_testlinkedserver (Transact-SQL)
sp_foreignkeys

See Also

System Stored Procedures (Transact-SQL)