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

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -