February 27, 2006 at 9:45 am
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
There could be too many statistics.
sp_helpstats shows the statistics on the table.
March 3, 2006 at 12:57 pm
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
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