Distributed Queries Stored Procedures (Transact-SQL)

Applies to: SQL Server (all supported versions)

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

sp_addlinkedserver

sp_addlinkedsrvlogin

sp_catalogs

sp_column_privileges_ex

sp_columns_ex

sp_droplinkedsrvlogin

sp_dropserver (Transact-SQL)

sp_foreignkeys

sp_indexes

sp_linkedservers

sp_primarykeys

sp_serveroption

sp_table_privileges_ex

sp_tables_ex

sp_testlinkedserver (Transact-SQL)

See Also

System Stored Procedures (Transact-SQL)