BUG: SQL Server Books Online Incorrectly Lists Updsts Switch for Sqlmaint Utility (311186)
The information in this article applies to:
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.
REFERENCES
SQL Server 7.0 Books Online; topic: "sqlmaint Utility"
| Modification Type: | Major | Last Reviewed: | 9/4/2002 |
|---|
| Keywords: | kbbug KB311186 |
|---|
|