Indexes on SQL Server table

Question

Is there a limit on the number of indexes a database table can have in SQL Server?

Thanks

Answer 1

For SQL Server 2008 R2 the Maximum Capacity Specification is here:

There you will see that the 2008 R2 edition allows for 999 non-clustered indexes and one clustered index per table.