Microsoft KB Archive/96234

{|
 * width="100%"|

INF: Meaning of USER ATTENTION SIGNAL Error

 * }

Q96234

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2
 * Microsoft SQL Server version 4.2x

-

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 &quot;SQL Administrator for Windows User's Guide&quot; 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 &quot;Configuration Guide&quot; 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

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2