Results 1 to 4 of 4

Thread: Index problem

  1. #1
    Join Date
    Mar 2010
    Posts
    2

    Index problem

    I tried adding a new index to a table today and got the following error message.

    Error: Message 1910 cannot create more then 249 non-clustered indexes or column stats on one table.

    I never had this before and I am not sure how to clear it so I can add an index I need for performance.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    That means table has 249 indices and column statistics already, drop some unused ones first.

  3. #3
    Join Date
    Mar 2010
    Posts
    2
    the table only has 3 indexes on it. any ideas?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Then check how many statistics it has.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •