indexing problem

From: Mehran (anonymous_at_discussions.microsoft.com)
Date: 05/05/04


Date: Wed, 5 May 2004 02:11:46 -0700

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