Post reply

Cannot create more than 249 nonclustered indices or column statistics on one table

  • February 27, 2006 at 9:45 am

    #171249

    We have vendor attempting to create an index on a table that currently contains a single index.  They are getting the message: cannot create more than 249 nonclustered indices or column statistics on one table. Any ideas?

  • February 27, 2006 at 10:35 am

    #623495

    There could be too many statistics.

    sp_helpstats shows the statistics on the table.

  • March 3, 2006 at 12:57 pm

    #624715

    If you prefer seeing it from Enterpise Manager, change the view to Taskpad, Select the Table Info tab and Scroll down or Next to the table desired.  All of the indexes for a table are listed after it including the ones created automatically for statistics (begin with _WA).

    Steve

  • March 9, 2009 at 4:01 am

    #955856

    Hi swede,

    you may want to visit below site. but the solution is applicable for MSSQL 2000.

    http://www.developerdotstar.com/community/node/503

    Regards,

    Renan A.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply