Security Manager reports incorrect percentage of free space available on database computer. (NETIQKB21625)

  • 7721625
  • 02-Feb-2007
  • 09-Oct-2007

Resolution

fact
Security Manager 3.X

fact
Security Manager 4.X

symptom
Security Manager reports incorrect percentage of free space available on database computer.

cause
This problem occurs due to inaccuracies in the 'Sysindexes' table, which may result in incorrect space usage reports by the'sp_spaceused' system stored procedure.

fix

Run the following query using Sql Query Analyzer to correct the problem.

  • DBCC UPDATEUSAGE ("ONEPOINT') WITH NO_INFOMSGS


Additional Information

Formerly known as NETIQKB21625