Problem about indexes

• Erdem-307341

  Grasshopper

  Points: 13

  More actions

  March 4, 2006 at 9:16 am

  #189552

  They are getting the message: cannot create more than 249 nonclustered indices or column statistics on one table.

   

  I am gettinf this mesage but there is only one index existing in my table.How do i get rid of this message?

• Jo Pattyn

  SSC-Dedicated

  Points: 32347

  More actions

  March 5, 2006 at 7:12 am

  #624785

  The same problem was in a thread only a week old. I'll see if I can find it

• Okafor

  Mr or Mrs. 500

  Points: 596

  More actions

  March 7, 2006 at 6:44 am

  #625159

  I think this will answer your question...

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=14052

  Good luck.