DOCUMENT:Q191353 31-JUL-2001 [sms] TITLE :SMS: SMS SQL View Generator Not Completely Silent in Unattended PRODUCT :Microsoft Systems Management Server PROD/VER:winnt:1.2 OPER/SYS: KEYWORDS:kbsmsUtil smsutil ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Systems Management Server version 1.2 ------------------------------------------------------------------------------- SYMPTOMS ======== Using the SMS SQL View Generator (Smsview.exe), you can create database views on the Systems Management Server database. The SMS SQL View Generator creates views for all personal computer groups that exist in the database at the time it is run. The Systems Management Server Books Online describes that utility as follows: From the SMS\SITE.SRV\platform directory, you can run the SMS SQL View Generator from the command line using the following syntax: smsview Options are any of the following: /s: Specifies the name of the computer running the instance of SQL Server containing the database. /l: Specifies a login ID on SQL Server that has database owner (dbo) permissions on the database. /p: Specifies the password for the login ID you specified with the /l: option. /d: Specifies the name of the site database. For example: smsview /s:smsdbsrv /l:smsdbo /p:alpha /d:sms The command line allows you to use the SMS SQL View Generator in a batch file or other scheduled process. No messages are displayed on the console. When the SMS SQL View Generator is run as a command, success or failure of the command is logged to the application log of the Windows NT event log. If the SMS SQL View Generator fails, the event provides a brief explanation of the cause (for example, if one of the command line arguments is invalid). All SMS SQL View Generator events have a source of SMS View. Note that the documentation states: No messages are displayed on the console. However, when the SMSVIEW executable is run from a command line, a dialog box is displayed stating that the Views were successfully created. The documentation also states: When the SMS SQL View Generator is run as a command, success or failure of the command is logged to the application log of the Windows NT event log. If the SMS SQL View Generator fails, the event provides a brief explanation of the cause (for example, if one of the command line arguments is invalid). All SMS SQL View Generator events have a source of SMS View. This is also incorrect. It does not log any information in the Windows NT event log. STATUS ====== Microsoft has confirmed this to be a problem in Systems Management Server version 1.2. For additional information about related issues, click the article number below to view the article in the Microsoft Knowledge Base: Q192439 SMS: Command Line Smsview.exe Leaves Open Window in Background SMS: Command Line Smsview.exe Leaves Open Window in Background Additional query words: prodsms ====================================================================== Keywords : kbsmsUtil smsutil Technology : kbSMSSearch kbSMS120 Version : winnt:1.2 Issue type : kbbug ============================================================================= 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. Copyright Microsoft Corporation 2001.