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.
  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.
  3. satya Moderator

Share This Page