BUG: Sqlmaint.exe Command Line Parameters

 Last reviewed: April 15, 1997
Article ID: Q156288

The information in this article applies to:
  • Microsoft SQL Server, versions 6.0 and 6.5

SYMPTOMS

The documentation for the Sqlmaint.exe utility has an incomplete description of the parameters and how to properly enter values when running the utility from the command line. If these values are not entered properly, the utility returns the help screen, as if you had typed: 

   sqlmaint /?
If the utility is called from a scheduled CmdExec task and the parameters and their values are not entered correctly, the task will fail. If you look at the history, you will see that the last error message for the task is a list of the valid parameters.

WORKAROUND

  • When entering parameters for the Sqlmaint.exe utility, type a space between the parameter and its supplied value.
  • When supplying a user name and password, place the name and password in double quotation marks.

For example, assume the sa's password is sa and a checkdb is run against pubs. Here is a valid command line entry: 

   sqlmaint -U "sa" -P "sa" -D pubs -Ckdb -Rpt c:\maint\pubs.txt
Also remember that, as stated in the documentation, the database and report file parameters are required.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: wizard
Keywords : kbbug6.50 kbusage
Version : 6.5
Platform : WINDOWS
Issue type : kbdocerr

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 15, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.