Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    26

    Unanswered: Strange Error when do DBCC DBREINDEX

    The error message is:
    Location: recbase.cpp:1371
    Expression: m_nVars > 0
    SPID: 52
    Process ID: 732
    ODBC: Message 0£¬severity 16£¬state 1
    Communication link failure
    ODBC: Message 0£¬severity 16£¬state 1
    Communication link failure

    god , I have never seen error like that!
    what will be reason for the error??
    ......

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    It looks like some issues with h/w where SQL server is hosted. Generally the assertion errors represent page on index is corrupted.
    Perform the following checks :
    -run DBCC CHECKDB on the database to determine any corruption
    -check the NT event log and SQL Server errorlog for previous
    errors/problems
    - Any hardware diagnostics

    BTW, what is level of service pack on SQL & OS?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jan 2004
    Posts
    26
    thanks! I will check the sp level of SQL...It may be a bug of SQL as Microsoft said.
    ......

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Cant' say until you confirm the service pack level and MS might have corrected with a fix or so.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •