indexing problem
From: Mehran (anonymous_at_discussions.microsoft.com)
Date: 05/05/04
- Next message: Vishal Parkar: "Re: how do I select len(foo) for an ntext field?"
- Previous message: marty: "how do I select len(foo) for an ntext field?"
- Next in thread: Steve Kass: "Re: indexing problem"
- Reply: Steve Kass: "Re: indexing problem"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Vishal Parkar: "Re: how do I select len(foo) for an ntext field?"
- Previous message: marty: "how do I select len(foo) for an ntext field?"
- Next in thread: Steve Kass: "Re: indexing problem"
- Reply: Steve Kass: "Re: indexing problem"
- Messages sorted by: [ date ] [ thread ]