United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

DROP Statements (Transact-SQL)

DROP AGGREGATE (Transact-SQL)

DROP APPLICATION ROLE (Transact-SQL)

DROP ASSEMBLY (Transact-SQL)

DROP ASYMMETRIC KEY (Transact-SQL)

DROP BROKER PRIORITY (Transact-SQL)

DROP CERTIFICATE (Transact-SQL)

DROP CONTRACT (Transact-SQL)

DROP CREDENTIAL (Transact-SQL)

DROP CRYPTOGRAPHIC PROVIDER (Transact-SQL)

DROP DATABASE (Transact-SQL)

DROP DATABASE AUDIT SPECIFICATION (Transact-SQL)

DROP DATABASE ENCRYPTION KEY (Transact-SQL)

DROP DEFAULT (Transact-SQL)

DROP ENDPOINT (Transact-SQL)

DROP EVENT NOTIFICATION (Transact-SQL)

DROP EVENT SESSION (Transact-SQL)

DROP FULLTEXT CATALOG (Transact-SQL)

DROP FULLTEXT INDEX (Transact-SQL)

DROP FULLTEXT STOPLIST (Transact-SQL)

DROP FUNCTION (Transact-SQL)

DROP INDEX (Transact-SQL)

DROP LOGIN (Transact-SQL)

DROP MASTER KEY (Transact-SQL)

DROP MESSAGE TYPE (Transact-SQL)

DROP PARTITION FUNCTION (Transact-SQL)

DROP PARTITION SCHEME (Transact-SQL)

DROP PROCEDURE (Transact-SQL)

DROP QUEUE (Transact-SQL)

DROP REMOTE SERVICE BINDING (Transact-SQL)

DROP RESOURCE POOL (Transact-SQL)

DROP ROLE (Transact-SQL)

DROP ROUTE (Transact-SQL)

DROP RULE (Transact-SQL)

DROP SCHEMA (Transact-SQL)

DROP SERVER AUDIT (Transact-SQL)

DROP SERVER AUDIT SPECIFICATION (Transact-SQL)

DROP SERVICE (Transact-SQL)

DROP SIGNATURE (Transact-SQL)

DROP STATISTICS (Transact-SQL)

DROP SYMMETRIC KEY (Transact-SQL)

DROP SYNONYM (Transact-SQL)

DROP TABLE (Transact-SQL)

DROP TRIGGER (Transact-SQL)

DROP TYPE (Transact-SQL)

DROP USER (Transact-SQL)

DROP VIEW (Transact-SQL)

DROP WORKLOAD GROUP (Transact-SQL)

DROP XML SCHEMA COLLECTION (Transact-SQL)

Minimize

This topic has not yet been rated - Rate this topic

DROP RESOURCE POOL (Transact-SQL)

SQL Server 2008

Drops a user-defined Resource Governor resource pool.

Topic link icon Transact-SQL Syntax Conventions.


DROP RESOURCE POOL pool_name
[ ; ]

pool_name: Is the name of an existing user-defined resource pool.

You cannot drop a resource pool if it contains workload groups.

You cannot drop the Resource Governor default or internal pools.

When you are executing DDL statements, we recommend that you be familiar with Resource Governor states. For more information, see Resource Governor States.

Requires CONTROL SERVER permission.

The following example drops the resource pool named big_pool.

DROP RESOURCE POOL big_pool
GO
ALTER RESOURCE GOVERNOR RECONFIGURE
GO

Reference

CREATE RESOURCE POOL (Transact-SQL)

ALTER RESOURCE POOL (Transact-SQL)

CREATE WORKLOAD GROUP (Transact-SQL)

ALTER WORKLOAD GROUP (Transact-SQL)

DROP WORKLOAD GROUP (Transact-SQL)

ALTER RESOURCE GOVERNOR (Transact-SQL)

Concepts

Resource Governor Concepts

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.