Run DBCC Utility Options for SQL Server - Intergraph Smart Instrumentation - 13.1 - Installation & Upgrade - Intergraph

Intergraph Smart Instrumentation Installation and Upgrade

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
13.1
  1. Click Start > Programs > Microsoft SQL Server > SQL Server Management Studio.

  2. Connect to the server.

  3. In the Microsoft SQL Server Management Studio window, under the Object Explorer, select the server (top-level node), right-click, and on the shortcut menu, click New Query.

  4. Type the appropriate query using the syntax shown, for example:

DBCC CHECKCATALOG ('Site_Server1_DB')

  • You must enclose the name of your database within quotes and parentheses as shown.

  • Identical syntax applies for the CHECKDB command.

  1. Click Query > Execute.

  2. View the Messages window for the results of the query.

    SHARED Tip You can save the results to an external file. To do so, click Query > Results To > Results to File.

The software automatically corrects basic problems. For more complex problems, you must refer to the query results and correct these problems manually.