In Sql Server 2008 32 Bit addition ,following are the limit for Non Cluster Index and Cluster Index
Clustered indexes per table: 1
None clustered per table: 999
Nested sub queries: 32
Nested trigger levels: 32
Parameters per stored procedure: 2100
Parameters per user-defined function: 210
Reference:
http://msdn.microsoft.com/en-us/library/ms143432.aspx
