Microsoft KB Archive/311186

= BUG: SQL Server Books Online Incorrectly Lists Updsts Switch for Sqlmaint Utility =

Article ID: 311186

Article Last Modified on 9/4/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q311186



BUG #: 53512(SQLBUG_70)

BUG #: 56286(SQLBUG_70)



SYMPTOMS
If you try to execute Sqlmaint.exe with the -UpdSts switch from a command prompt, the command fails to execute and lists the usage for Sqlmaint.exe.



CAUSE
The SQL Server Books Online documentation for the Sqlmaint utility is incorrect. UpdSts is not a valid switch in SQL Server 7.0.



WORKAROUND
To work around this problem, use -UpdOptiStats sample_percent instead.

For example:

sqlmaint -D pubs -Rpt C:\MSSQL7\Log\pubsmaint.txt -UpdOptiStats 10



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0 documentation.