The information in this article applies to:
BUG# NT: 681 (4.2) SYMPTOMSWhen issuing a RPC to a remote SQL Server for Windows NT, the client application hangs. The remote server will refuse to accept further connections and any currently connected clients that attempt to issue queries will hang. The remote server cannot be shut down with the service control manager. The SQLSERVR process must either be killed or the NT server cycled. CAUSE
If execution of RPC causes a trigger to be fired which in turn encounters a
non-fatal runtime error, such as a unique key or rule violation, and if
that trigger contains any statements after the point where the error
occurred, the symptoms noted above may occur.
WORKAROUNDCare must be taken to ensure that triggers will not cause non-fatal runtime errors. Logic should either be added to the trigger to guard against this, or any statements that might generate these errors should be placed in the stored procedure instead of the trigger. STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. This problem was corrected in the latest U.S. Service Pack for SQL Server version 4.21a. For information on obtaining the Service Pack, please contact your primary support provider. Additional query words: 4.20 calls password proc @@error Windows NT
Keywords : |
Last Reviewed: March 17, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |