• Hugo Kornelis (1/19/2010)


    I was not able to find the maximum number of full-text indexes per table. (I'm still hoping someone else finds this and posts a link).

    Here it is: http://msdn.microsoft.com/en-us/library/ms187317.aspx

    CREATE FULLTEXT INDEX (Transact-SQL)

    Only one full-text index is allowed per table or indexed view, and each full-text index applies to a single table or indexed view.

    Hugo Kornelis (1/19/2010)


    So the actual maximum is (499 + (maximum FT indexes per table)).

    And it's 500 🙂