• ok, thanks.

    I should have made a post earlier but I had a production issue.

    I was able to Delete all Indexes and the Primary Key.

    Now I'm having problems creating a Non CLUSTERED Index.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/