---
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)
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]

  [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] supports the following system stored procedures that are used to implement and manage Distributed Queries.  
  
|||  
|-|-|  
|[sp_addlinkedserver](../../relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql.md)|[sp_indexes](../../relational-databases/system-stored-procedures/sp-indexes-transact-sql.md)|  
|[sp_addlinkedsrvlogin](../../relational-databases/system-stored-procedures/sp-addlinkedsrvlogin-transact-sql.md)|[sp_linkedservers](../../relational-databases/system-stored-procedures/sp-linkedservers-transact-sql.md)|  
|[sp_catalogs](../../relational-databases/system-stored-procedures/sp-catalogs-transact-sql.md)|[sp_primarykeys](../../relational-databases/system-stored-procedures/sp-primarykeys-transact-sql.md)|  
|[sp_column_privileges_ex](../../relational-databases/system-stored-procedures/sp-column-privileges-ex-transact-sql.md)|[sp_serveroption](../../relational-databases/system-stored-procedures/sp-serveroption-transact-sql.md)|  
|[sp_columns_ex](../../relational-databases/system-stored-procedures/sp-columns-ex-transact-sql.md)|[sp_table_privileges_ex](../../relational-databases/system-stored-procedures/sp-table-privileges-ex-transact-sql.md)|  
|[sp_droplinkedsrvlogin](../../relational-databases/system-stored-procedures/sp-droplinkedsrvlogin-transact-sql.md)|[sp_tables_ex](../../relational-databases/system-stored-procedures/sp-tables-ex-transact-sql.md)|  
|[sp_dropserver (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dropserver-transact-sql.md)|[sp_testlinkedserver (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-testlinkedserver-transact-sql.md)|  
|[sp_foreignkeys](../../relational-databases/system-stored-procedures/sp-foreignkeys-transact-sql.md)||  
  
## See Also  
 [System Stored Procedures (Transact-SQL)](../../relational-databases/system-stored-procedures/system-stored-procedures-transact-sql.md)