United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2000

Microsoft SQL Server 2000

SQL Server 2000 Books Online

Transact-SQL Reference

DBCC

DBCC CHECKALLOC

DBCC CHECKCATALOG

DBCC CHECKCONSTRAINTS

DBCC CHECKDB

DBCC CHECKFILEGROUP

DBCC CHECKIDENT

DBCC CHECKTABLE

DBCC CLEANTABLE

DBCC CONCURRENCYVIOLATION

DBCC DBREPAIR

DBCC dllname (FREE)

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE

DBCC HELP

DBCC INDEXDEFRAG

DBCC INPUTBUFFER

DBCC NEWALLOC

DBCC OPENTRAN

DBCC OUTPUTBUFFER

DBCC PINTABLE

DBCC ROWLOCK

DBCC SHOWCONTIG

DBCC SHOW_STATISTICS

DBCC SHRINKDATABASE

DBCC SHRINKFILE

DBCC SQLPERF

DBCC TRACEOFF

DBCC TRACEON

DBCC TRACESTATUS

DBCC UNPINTABLE

DBCC UPDATEUSAGE

DBCC USEROPTIONS

Minimize

2 out of 3 rated this helpful - Rate this topic

DBCC DBREPAIR

SQL Server 2000

Drops a damaged database.

Important DBCC DBREPAIR is included in Microsoft® SQL Server™ 2000 for backward compatibility only. It is recommended that DROP DATABASE be used to drop damaged databases. In a future version of SQL Server, DBCC DBREPAIR may not be supported.

See Also

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.