Microsoft KB Archive/110985

FIX: Kill Then Net Session Loss Can Make Access Vio., Err 611

PSS ID Number: Q110985 Article last modified on 10-31-1994

4.20

Windows

BUG# NT: 642 (4.2)

= SYMPTOMS =

If you kill processes doing heavy tempdb inserts, then terminate the client network sessions with net session/delete, under rare conditions, this may generate an access violation followed by a server hang. Often error 611 is seen. It will also sometimes happen if instead of net session/delete, you just kill all the client sessions individually by rebooting all of the client machines.

= WORKAROUND =

Do not terminate net connections following use of Transact SQL kill command.

= STATUS =

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. This problem was corrected in SQL Server version 4.21. For more information, contact your primary support provider.

Additional reference words: 4.20 Windows NT KBCategory: kbother kberrmsg KBSubcategory: SSrvWinNT

=
================================================================

Copyright Microsoft Corporation 1994.