System: Retrieve Size for CUIC Database Tables

From DocWiki

Jump to: navigation, search

System: Retrieve Size for CUIC Database Tables

Problem Summary You want to determine the current size of the CUIC database tables.
Error Message None.
Possible Cause You are concerned that some tables are growing too large.
Recommended Action In the SQL Server Management Studio, Open New Query window.
  1. Select the CUIC database.
  2. Run the following SQL Statement in Query Window: select 'exec sp_spaceused ' + name from sysobjects where type = 'U'.
    Note Note: There is a space after 'spaceused" and the '.
  3. Copy the Result of this query.
  4. Open another new Query Window.
  5. Paste the query.
  6. Select the CUIC database.
  7. Run (execute) the query.

The result of the query displays information about all tables in CUIC database including size and number of rows in the table.

Release Release 7.5(2).
Associated CDETS # None.

Rating: 0.0/5 (0 votes cast)

Personal tools