indexing problem

Hi!
I have a table with name "Bestand". The table has 280
columns. I thought to do an index for some columns,
because i heard that you are going to get faster results
if you do some indexes.
But i get this error:
'BESTAND' table
- Unable to create index 'IX_BESTAND'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Cannot create more than 249 nonclustered indices
or column statistics on one table.
Is there anyone who know the answer why i get that
error?
Thank you for helping me
Kind Regards
Mehran
Mehran,
You cannot create an unlimited number of indexes on one table, and you
have reached SQL Server's limit. The error message means just what it
says, and is probably occurring when you try to create the 250th index
on the table.
Steve Kass
Drew University
Mehran wrote:

>Hi!
>I have a table with name "Bestand". The table has 280
>columns. I thought to do an index for some columns,
>because i heard that you are going to get faster results
>if you do some indexes.
>But i get this error:
>'BESTAND' table
>- Unable to create index 'IX_BESTAND'.
>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
>Server]Cannot create more than 249 nonclustered indices
>or column statistics on one table.
>Is there anyone who know the answer why i get that
>error?
>Thank you for helping me
>Kind Regards
>Mehran
>