DBCC CLEANTABLE in Microsoft SQL Server

DBCC CLEANTABLE

Reclaims space for dropped variable length columns and text columns.

Syntax

DBCC CLEANTABLE     ( { 'database_name' | database_id }
, { 'table_name' | table_id | 'view_name' | view_id }
[ , batch_size ]
)

DBCC CLEANTABLE is not supported for use on system tables or temporary tables.
This operation is fully logged.

DBCC CONCURRENCYVIOLATION
Displays statistics on how many times more than eight operations were run concurrently on SQL Server 2000 Desktop Engine (MSDE 2000) or SQL Server 2000 Personal Edition. Also Controls whether these statistics are also recorded in the SQL Server error log.

Syntax

DBCC CONCURRENCYVIOLATION [ ( DISPLAY | RESET | STARTLOG | STOPLOG ) ]

Remarks
DBCC CONCURRENCYVIOLATION can be executed on any Edition of SQL Server 2000, but is only effective on the SQL Server 2000 editions that have a concurrent workload governor: SQL Server 2000 Desktop Engine (MSDE 2000) and SQL Server 2000 Personal Edition. On all other editions, it has no effect other than returning the message: DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.