f_ernestog (1/19/2010)
the link that is offered as the documentation doesn't says the maximum number of indexes allowed, just redirects you to the "Create Index" T-SQL documentation, and there it doesn't says that amount.
Check carefully, and you will find the following:
CLUSTERED
A table or view is allowed one clustered index at a time.
NONCLUSTERED
Each table can have up to 999 nonclustered indexes, regardless of how the indexes are created: either implicitly with PRIMARY KEY and UNIQUE constraints, or explicitly with CREATE INDEX.
But there are also XML, full-text, and spatial indexes (as Hugo mentioned earlier). The question doesn't say that we must consider only clustered and nonclustered indexes.