Microsoft KB Archive/117367

{|
 * width="100%"|

FIX: SQL Server FixList for Version 4.21.004
'Article ID: Q117367

Creation Date: 27-JUN-1994

Revision Date: 29-APR-1997' 

The information in this article applies to:

- Microsoft SQL Server version 4.21 The following is a list of fixes and other various improvements that have been made in SQL Server version 4.21.004. SQL Server version 4.21.004 is now available from your primary support provider. For more information, contact your primary support provider.

Please note that workarounds have been provided for your information only. It is not necessary to implement these workarounds if you have the updated software.

List of Problems Corrected in 4.21.004


 * FIX: RPC from SQL NT Fails After 60 Seconds
 * FIX: "LAZY WRITER" CMD in SYSPROCESSES is NULL Terminated

Description of Problems Corrected in 4.21.004

FIX: RPC from SQL NT Fails After 60 Seconds

ARTICLE ID: \[\[..\/\|Q\]\] BUG# NT: 694 (4.2)

SYMPTOMS

When executing a remote procedure call from a local SQL Server for Windows NT to a remote server or ODS application, the RPC execution fails. The client process receives either a nonsensical error message or is disconnected due to an access violation. The stored procedure will execute correctly if it is run directly on the remote server using a client application.

Possible errors include:

Access violations causing the client process to be disconnected Msg 7221 Message too long. Length = Msg 7221, login to site '' failed results never returned to front end, query must be canceled CAUSE

An RPC execution issued from NT SQL Server will timeout after 60 seconds of execution. This failure can result in a variety of error messages and behaviors depending on the number and timing of results ( if any ) being returned from the remote procedure.

WORKAROUND

Ensure that the total execution time of any remote stored procedure executed by a NT SQL Server is under 60 seconds.

FIX: "LAZY WRITER" CMD in SYSPROCESSES is NULL Terminated

ARTICLE ID: \[\[..\/\|Q\]\] BUG# NT: 690 (4.21)

SYMPTOMS

On SQL Server for Windows NT, the "LAZY WRITER" process has a null terminated string in the CMD column in SYSPROCESSES. All other processes, both system and user, are padded out with spaces to the full column length.

MORE INFORMATION

Some applications depend on the padded string behavior. SQL Administrator, for instance, will erroneously display the process as "LAZY WRITER UN" because of this null termination problem.
 * }

-

 Additional query words: Windows NT

Keywords : SSrvWinNT kbfixlist

Version : 4.21

Platform : WINDOWS

Issue type : kbref

"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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''