• In SQL Server 2005 :

    you can have

    1 Clustered Index on a table and

    249 Non Clustered Indexes.

    = 250 Index

    In SQL Server 2008:

    you can have

    1 Clustered Index on a table and

    999 Nonclustered Indexes

    = 1000 Index

    Please Modify the Question Or Answers....!

    I think Raj gave right solution ...!