SQL Server Performance

Urgently - Sql generate duplicate spid

Discussion in 'Performance Tuning for DBAs' started by hcejas, Jun 10, 2004.

  1. hcejas New Member

    Using Enterprise Manager - Current Activity recive the message

    Error 1505: create unique index terminates because a duplicate key was found most significant primary key is 63.

    The Table sysprocess how me only one spid 63. The Artisan tool show me 2 processes 63.

    How delete this process 63. The alternative was stop the Sql Server, but the second day appear the problem.

    Thanks in advance.

    Heraclio Cejas C.
    hcejas, Jun 10, 2004
    #2

  2. derrickleggett New Member

    Do you have the latest service pack 3a installed? What version of SQL Server are you running? What version/service pack of windows?

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
    derrickleggett, Jun 10, 2004
    #2

  3. satya Moderator

    satya, Jun 10, 2004
    #2

Share This Page