sp_dbcc_alterws

Description

Changes the size of the specified workspace to a specified value, and initializes the workspace.

Syntax

sp_dbcc_alterws dbname, wsname, "wssize[K|M]"

Parameters

dbname

is the name of the database in which the workspace resides. Specify either dbccdb and dbccalt.

wsname

specifies the name of the workspace to alter.

wssize

is the new size of the workspace, specified by K (kilobytes) or M (megabytes). If you do not specify K or M, wssize specifies the number of pages. Page size is platform-dependent. The minimum size for a workspace is 24 pages.

Examples

Example 1

Changes the size of the scan_ws_000001 workspace on dbccdb to 30MB:

sp_dbcc_alterws dbccdb, scan_ws_000001, "30M"
Workspace scan_ws_000001 has been altered successfully to size 30MB

Usage

Permissions

Only a System Administrator or the Database Owner can run sp_dbcc_alterws.

See also

See the System Administration Guide for more information on the scan and text workspaces, and the dbccalt database.

Commands dbcc

dbcc stored procedures sp_dbcc_createws, sp_dbcc_evaluatedb

System procedures sp_plan_dbccdb, sp_helpdb