---
title: "sys.sp_xtp_unbind_db_resource_pool (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"
f1_keywords: 
  - "sp_xtp_unbind_db_resource_pool_TSQL"
  - "sp_xtp_unbind_db_resource_pool"
  - "sys.sp_xtp_unbind_db_resource_pool_TSQL"
  - "sys.sp_xtp_unbind_db_resource_pool"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "sp_xtp_unbind_db_resource_pool"
  - "sys.sp_xtp_unbind_db_resource_pool"
ms.assetid: 695a796d-087e-4bc8-99d0-ddc342604c75
author: "stevestein"
ms.author: "sstein"
---
# sys.sp_xtp_unbind_db_resource_pool (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2014-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2014-xxxx-xxxx-xxx-md.md)]

  This system procedure removes an existing binding between a database and a resource pool for purposes of tracking [!INCLUDE[hek_2](../../includes/hek-2-md.md)] memory usage.  If there is no pool currently bound to the specified database, success is returned. When the database is unbound, the previously allocated memory for memory-optimized objects stays allocated to the previous resource pool. You need to restart the database to free up the allocated memory. Once a database is unbound from the resource pool, the binding resorts to the DEFAULT resource pool.  
  
 ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
  
## Syntax  
  
```sql  
sys.sp_xtp_unbind_db_resource_pool 'database_name'  
```  
  
## Arguments  
 database_name  
 The name of an existing [!INCLUDE[hek_2](../../includes/hek-2-md.md)] enabled database.  
  
#### Parameters  
  
## Messages  
 If database was bound to a named resource pool, the procedure returns successfully. However, You must restart the database for unbinding to take effect.  
 If there is no existing binding for the database specified, `sp_xtp_unbind_db_resource_pool` returns success, but gives the informational message:  
  
```  
Msg 41374, Level 16, State 1, Procedure sp_xtp_unbind_db_resource_pool_internal, Line 140.  
Database 'Hekaton_DB' does not have a binding to a resource pool.  
  
```  
  
## Example  
 The following code unbinds the database Hekaton_DB from the [!INCLUDE[hek_2](../../includes/hek-2-md.md)] resource pool it is bound to.  If Hekaton_DB is not currently bound to a [!INCLUDE[hek_2](../../includes/hek-2-md.md)] resource pool, a message is given. The database must be restarted for the unbinding to take effect.  
  
```sql  
sys.sp_xtp_unbind_db_resource_pool 'Hekaton_DB'  
```  
  
## Requirements  
  
-   The database specified by `database_name` must have a binding to an [!INCLUDE[hek_2](../../includes/hek-2-md.md)] resource pool.  
  
-   Requires CONTROL SERVER permission.  
  
## See Also  
 [Bind a Database with Memory-Optimized Tables to a Resource Pool](../../relational-databases/in-memory-oltp/bind-a-database-with-memory-optimized-tables-to-a-resource-pool.md)   
 [sys.sp_xtp_bind_db_resource_pool (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-xtp-bind-db-resource-pool-transact-sql.md)