distributed-queries-stored-procedures-transact-sql.md

title	Distributed Queries Stored Procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	system stored procedures [SQL Server], distributed queries distributed queries [SQL Server], stored procedures
ms.assetid	0fbf2846-885e-4de2-b552-f6453c3ca136
author	CarlRabeler
ms.author	carlrab

Distributed Queries Stored Procedures (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

[!INCLUDEssNoVersion] 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)