Thread: SQL Server 2005
View Single Post
  #30 (permalink)  
Old 10-27-2007, 02:52 AM
kingmaker kingmaker is offline
D-Web Genius
 
Join Date: Jun 2007
Posts: 882
kingmaker is on a distinguished road
Send a message via Yahoo to kingmaker
Default DBCC CHECKFILEGROUP SQL Server 2005

DBCC CHECKFILEGROUP - Check the allocation and structural integrity of all tables and indexed views in a filegroup.

Syntax
DBCC CHECKFILEGROUP
[( 'filegroup' | filegroup_id | 0
[, NOINDEX ]
)]
[WITH
[ALL_ERRORMSGS
NO_INFOMSGS]
[, TABLOCK ] [ , ESTIMATEONLY ]
]
Key:
filegroup_name - The name of the filegroup to be checked.
default (or if 0 is specified) = the primary filegroup.
NOINDEX - Skip intensive checks of nonclustered indexes.
ALL_ERRORMSGS - Return all reported errors per object, default = first 200 errors.
TABLOCK - Obtain locks instead of using an internal database snapshot.
ESTIMATEONLY - Display the estimated amount of tempdb space that would be required.

Examples

-- Check the primary filegroup in 'MyDatabase'
USE MyDatabase;
GO
DBCC CHECKFILEGROUP;
GO
__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)
Reply With Quote