Hugo Kornelis (1/19/2010)
For SQL Server 2008:Up to 1 clustered index, up to 999 nonclustered indexes, and up to 999 XML indexes (http://msdn.microsoft.com/en-us/library/ms143432.aspx), plus a number of full-text indexes and a number of spatial indexes for which I was unable to find the maximums.
249 XML indexes, actually.
The maximum number of spatial indexes can be found here: http://msdn.microsoft.com/en-us/library/ms190197.aspx, and it's 249.
So the correct answer for SQL Server 2008 is "1 clustered + 999 nonclustered + 249 XML + 249 spatial + some full-text", which is "1498 + some full-text".