SQL Server fails with fatal error.

From: Oleg Rakitskiy (raol_at_univ.kiev.ua)
Date: 12/11/04

  • Next message: -Permood: "Re: BEST UDF to handle char or varchar to smalldatatime converstio" 
    Date: Sat, 11 Dec 2004 22:16:41 +0200

    Hi. I've got very interesting situation with my SQL Server. There was
    few fails during past month. I check my database with DBCC CHECKDB
    ('...') and notice that any errors are absent. But SQL Server fails
    with 17055 event.
    Here is whole message from error log.

    MSSQLSERVER
    17055

    17066 :
    SQL Server Assertion: File: <c_events.cpp>, line=443 Failed Assertion =
    'pPss->psrvproc->srvio.n_outbuff ==
    ((USHORT)pPss->psrvproc->CbPacketSize()) - sizeof( SRV_TDSHDR)'.

    And here is a piece of sql dump

    This file is generated by Microsoft SQL Server 8.00.879

    upon detection of fatal unexpected error. Please return this file,

    the query or program that produced the bugcheck, the database and

    the error log, and any other pertinent information with a Service
    Request.
     

    Computer type is AT/AT COMPATIBLE.

    Bios Version is COMPAQ - 2

    Current time is 10:24:08 12/10/04.

    8 Intel x86 level 15, 1999 Mhz processor(s).

    Windows NT 5.2 Build 3790 CSD .

    .....

    Hardware: HP Proliant ML 570.
    Can anyone give me a suggestion about this problem. I'm in seriuos
    trouble. :(

    Thank you.

  • Next message: -Permood: "Re: BEST UDF to handle char or varchar to smalldatatime converstio"

    Relevant Pages

    • SQL Server does not exist or access denied
      ... I get the error both in application code and from Enterprise Manager. ... The database is LOCAL. ... Microsoft SQL Server 2000 Developer Edition SP4 ... Once it fails, it will fail ...
      (comp.databases.ms-sqlserver)
    • SQL Server does not exist or access denied
      ... I get the error both in application code and from Enterprise Manager. ... The database is LOCAL. ... Microsoft SQL Server 2000 Developer Edition SP4 ... Once it fails, it will fail ...
      (comp.databases.ms-sqlserver)
    • Re: Error Log file location causing Failover failure?
      ... We have a SQL Server on a 2 node cluster. ... Like SQL was looking for the error log file on the C:\ drive ...
      (microsoft.public.sqlserver.clustering)
    • Re: Unable to connect to SQLExpress Remotely - no matter what
      ... Still no luck after as full of a reinstall as I could manage. ... Nothing to the error log. ... Another note is that I'm connecting using SQL Server Authentication. ...
      (microsoft.public.sqlserver.connect)
    • Re: Problem with MSDE database
      ... I have seen that error message in the Error log ... Starting up database 'Allcomp'. ... > Can you check the SQL Server error log file for more informations for the ... > cause for Suspect status.base on that we will be able to rectify the issue. ...
      (microsoft.public.sqlserver.msde)
    Loading