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

SmartPlant Instrumentation Installation and Upgrade Guide
Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
2016 SP1 (11.0.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.

  5. Click Query > Execute.

  6. 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.