Clustered PK and deadlocks

• GARCIA

  SSC Enthusiast

  Points: 111

  More actions

  May 11, 2006 at 2:05 am

  #172440

  Hi everybody,

  we are living a strange issue with clustered indexes onto PK.

  we are maintaining a SQL 7 database converted into SQL 2000 for a few month.

  During conversion our client made a hand made script who recreate all objects from scratch in order to change collation. into this script he forgot to recreate Clustered PK Indexes.

  At now we want to recreate clustered indexes onto PK, but our application hangs up and causes deadlocks.

  With clustered PK under SQL 7.0 as far as we remind, no problem.

  With non clustered PK under SQL 2000, no problem.

  With non clustered PK + another clustered index onto ID under SQL 2000, no problem.

  With clustered PK onto SQL 2000 -> deadlocks caused by Index use.

  does anyone have the same problem or could help me ?

  thanks for your replies

  Fred.

• GARCIA

  SSC Enthusiast

  Points: 111

  More actions

  May 11, 2006 at 2:08 am

  #637173

  Sorry, I post my thread onto wrong forum, I post it into SQL Server 7, 2000 administration.