Run DBCC Utility Options for SQL Server - Intergraph Smart Engineering Manager - 2019 (10.0) - Installation & Upgrade - Hexagon

Intergraph Smart Engineering Manager Installation and Upgrade
Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Installation & Upgrade
Smart Electrical Version
2019 (9.0)
Smart P&ID Version
9 (2019)
Smart Engineering Manager Version
10 (2019)

  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.