Replication Indicies limit

• Jason Smith-202529

  SSC Rookie

  Points: 25

  More actions

  January 19, 2005 at 10:32 am

  #183943

  HI.

  I am trying to set up a merge replication . I have gone through the wizard and sucecessuly created the agent to create the snapshot. However when the agent runs it reports an error of "Cannot create more than 249 nonclustered indices or column statistics on one table". I take it this means that the agent is trying to add a column to a table for replication but is unable to due the amout of columns alreday in the table.

   

  Is there a way around this ?

   

   

  Many Thanks

• James Butler-205844

  Newbie

  Points: 5

  More actions

  February 2, 2005 at 10:10 am

  #540198

  You cannot create an unlimited number of indexes on one table - You

  have reached SQL Server's limit when trying to create the 250th index on the table.