Re: indexing problem
From: Steve Kass (skass_at_drew.edu)
Date: 05/06/04
- Previous message: Hugo Kornelis: "Re: => Unorthodox DB Updates - Trigger order"
- In reply to: Mehran: "indexing problem"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 06 May 2004 13:12:30 -0400
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
>
>
- Previous message: Hugo Kornelis: "Re: => Unorthodox DB Updates - Trigger order"
- In reply to: Mehran: "indexing problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
