• And be sure that you do not have any Foregin Key from other tables which is referenced to the PK ( Your Clustered Index)

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]