---
title: "Management Data Warehouse Stored Procedures (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "03/03/2017"
ms.prod: "sql-non-specified"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "management data warehouse, data collector stored procedures"
ms.assetid: bc492b18-6965-4bb5-8065-fe2641d29590
caps.latest.revision: 9
author: "JennieHubbard"
ms.author: "jhubbard"
manager: "jhubbard"
---
# Management Data Warehouse Stored Procedures (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2012-all_md](../../includes/tsql-appliesto-ss2012-all-md.md)]

  The data collector stores data and data collector type information in the management data warehouse. The following stored procedures are used to update data and change the tables in the management data warehouse.  
  
|||  
|-|-|  
|[core.sp_create_snapshot (Transact-SQL)](../../relational-databases/system-stored-procedures/core-sp-create-snapshot-transact-sql.md)|[core.sp_update_data_source (Transact-SQL)](../../relational-databases/system-stored-procedures/core-sp-update-data-source-transact-sql.md)|  
|[core.sp_add_collector_type (Transact-SQL)](../../relational-databases/system-stored-procedures/core-sp-add-collector-type-transact-sql.md)|[core.sp_remove_collector_type (Transact-SQL)](../../relational-databases/system-stored-procedures/core-sp-remove-collector-type-transact-sql.md)|  
|[core.sp_purge_data (Transact-SQL)](../../relational-databases/system-stored-procedures/core-sp-purge-data-transact-sql.md)||  
  
## See Also  
 [Data Collector Stored Procedures (Transact-SQL)](../../relational-databases/system-stored-procedures/data-collector-stored-procedures-transact-sql.md)