Reclaims space for dropped variable length columns and text columns

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.