United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

DBCC (Transact-SQL)

DBCC CHECKALLOC (Transact-SQL)

DBCC CHECKCATALOG (Transact-SQL)

DBCC CHECKCONSTRAINTS (Transact-SQL)

DBCC CHECKDB (Transact-SQL)

DBCC CHECKFILEGROUP (Transact-SQL)

DBCC CHECKIDENT (Transact-SQL)

DBCC CHECKTABLE (Transact-SQL)

DBCC CLEANTABLE (Transact-SQL)

DBCC CONCURRENCYVIOLATION (Transact-SQL)

DBCC DBREINDEX (Transact-SQL)

DBCC DBREPAIR (Transact-SQL)

DBCC dllname (FREE) (Transact-SQL)

DBCC DROPCLEANBUFFERS (Transact-SQL)

DBCC FREEPROCCACHE (Transact-SQL)

DBCC FREESESSIONCACHE

DBCC FREESYSTEMCACHE

DBCC HELP (Transact-SQL)

DBCC INDEXDEFRAG (Transact-SQL)

DBCC INPUTBUFFER (Transact-SQL)

DBCC OPENTRAN (Transact-SQL)

DBCC OUTPUTBUFFER (Transact-SQL)

DBCC PINTABLE (Transact-SQL)

DBCC PROCCACHE (Transact-SQL)

DBCC SHOW_STATISTICS (Transact-SQL)

DBCC SHOWCONTIG (Transact-SQL)

DBCC SHRINKDATABASE (Transact-SQL)

DBCC SHRINKFILE (Transact-SQL)

DBCC SQLPERF (Transact-SQL)

DBCC TRACEOFF (Transact-SQL)

DBCC TRACEON (Transact-SQL)

DBCC TRACESTATUS (Transact-SQL)

DBCC UNPINTABLE (Transact-SQL)

DBCC UPDATEUSAGE (Transact-SQL)

DBCC USEROPTIONS (Transact-SQL)

Minimize

0 out of 8 rated this helpful - Rate this topic

DBCC DBREPAIR (Transact-SQL)

SQL Server 2005

Drops a damaged database.

Important:
This feature is not available in SQL Server 2005. Use DROP DATABASE instead.

Reference

DBCC (Transact-SQL)
DROP DATABASE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

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.