Post reply

Connection Broken when a specific column is selected

  • September 7, 2007 at 6:51 am

    #120383

    Hi,

    I am firing a select query on a table with approx 200K+ records. There is a column in this table called country_no. When I select this column in where clause it gives the following error,

     

    Server: Msg 3624, Level 20, State 1, Line 1

     

    Connection Broken

    This column has a nonclustered nonunique index. Data type is int.

    Any idea as why this happens only when a specfic column is selected?

    Thanks in advance.

    Regards,

    Rohit

  • September 7, 2007 at 6:58 am

    #732119

    Rohit

    This information about your error is available in Books Online.  Have you checked your error message and run DBCC CHECKDB?

    A

    system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.

    John

  • September 7, 2007 at 3:26 pm

    #732278

    if this is SQL Server 2000 you should apply latest service pack.


    * Noel

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply