DBCC CHECKDB to check errors in SQL Server database -
is possible run: dbcc checkdb
on specific table in sql server 2005 database?
i have following syntax:
dbcc checkdb [ [ ( database_name | database_id | 0 [ , noindex | , { repair_allow_data_loss | repair_fast | repair_rebuild } ] ) ] [ { [ all_errormsgs ] [ , extended_logical_checks ] [ , no_infomsgs ] [ , tablock ] [ , estimateonly ] [ , { physical_only | data_purity } ] } ] ]
but keep getting incorrect syntax. want run see errors throws up? can me writing syntax? want remove repair options.
dbcc checkdb
names apply checking databases.
there dbcc checktable
command checking specific tables. usage is:
dbcc checktable ('yourtable');
Comments
Post a Comment