Update Statistics for SQL Server - Intergraph Smart Engineering Manager - 3.0 - Installation & Upgrade - Hexagon

Intergraph Smart Engineering Manager Web Installation and Configuration

Language
English
Product
Intergraph Smart Engineering Manager
Subproduct
Web
Search by Category
Installation & Upgrade
Smart Engineering Manager Web Version
3.0
  1. Select Start > 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, select New Query.

  4. Enter the following SQL script with the name of your database, for example:

    USE Site_Server1_DB
    GO
    EXEC SP_UPDATESTATS

    This script updates the statistics for every table in the database.