INF: Meaning of USER ATTENTION SIGNAL Error

 Last reviewed: April 28, 1997
Article ID: Q96234

The information in this article applies to: 

  - Microsoft SQL Server version 4.2 for OS/2
  - Microsoft SQL Server version 4.2

SUMMARY

A backup scheduled from SQL Administrator may fail, leaving the following message in the backup history: 

   DUMP DATABASE has been interrupted by a USER ATTENTION SIGNAL

MORE INFORMATION

The USER ATTENTION SIGNAL error is generated when the SQL Monitor times out while waiting for a reply to a command it has sent to Microsoft SQL Server.

The OS/2 SQL Monitor timeout interval is set by the /sqltimeout or -O parameter. Refer to page 7 of the "SQL Administrator for Windows User's Guide" for more information, or query on the following words in the Microsoft Knowledge Base: 

   monitor and sql and administrator and advantage
For the Windows NT SQL Monitor, the timeout is controlled by the following key in the Windows NT Registry:

HKEY-LOCAL-MACHINE 

 SOFTWARE
   MICROSOFT
     SQLSERVER
        SQLMONITOR
           PARAMETERS
                SqlTimeOut
Page 133 of the Microsoft SQL Server "Configuration Guide" states that this value is in hexadecimal seconds; however, this is a documentation error. The value should be entered in decimal seconds and needs to be long enough to cover the longest dump you may run.

The timeout parameter has a default of 180 seconds. If the backup history begins showing USER ATTENTION SIGNAL errors, find out the length of time a dump of the associated entity normally takes and increase the timeout parameter to cover that time period.

Additional query words: Windows NT
Keywords : kbother SSrvMon SSrvWinNT
Version : 4.2 | 4.2
Platform : OS/2 WINDOWS
Issue type : kbtshoot

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 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.