Error messages 1910; cannot create more than 250 indexes in one table

Hi all,
I am having problems to rebuild or create a new index at SQL server 6.5. It
is always give me error message:1910 " cannot create more than 250 indexes i
n one table. While I am only having 5 indexes in this table. I really don't
know what's went wrong sinc
e it was alright for all this years.
I really need help to deal with this problem since the table is the main tra
nsaction in our application system.
Thanks in advance run sp_help tablename
and put the output here so that myself or even our fellow newsgroup friends
can get more idea about the error
also check this link
http://msdn.microsoft.com/library/d...serr_1_733k.asp
Regards,
MD
"Femmy" <anonymous@.discussions.microsoft.com> wrote in message
news:9BC246D8-38BF-40DE-AF28-341F23C8DB2E@.microsoft.com...
> Hi all,
> I am having problems to rebuild or create a new index at SQL server 6.5.
It is always give me error message:1910 " cannot create more than 250
indexes in one table. While I am only having 5 indexes in this table. I
really don't know what's went wrong since it was alright for all this years.
> I really need help to deal with this problem since the table is the main
transaction in our application system.
> Thanks in advance |||Here is the output of sp_help tablename
Name Owner Type
When_created
-- -- --
--- --
--
mc_admission dbo user table
3 Sep 1998 7:06PM
Data_located_on_segment
--
default
Column_name Type Length Prec S
cale Nullable TrimTrailingBlanks
FixedLenNullInSource
-- -- -- -- -
-- -- --
--
ac_no char 10
no yes
no
ur_no char 10
no yes
no
bill_no char 10
no yes
no
bill_date datetime 8
no (n/a)
(n/a)
appr_no char 10
yes yes
yes
adm_type char 2
no yes
no
co_code char 5
no yes
no
mem_code char 5
no yes
no
mem_name varchar 40
yes yes
no
cl_code char 5
no yes
no
adm_doc char 6
no yes
no
ref_fr_doc_code char 6
yes yes
yes
ref_to_doc_code char 6
yes yes
yes
adm_date datetime 8
no (n/a)
(n/a)
dischg_date datetime 8
yes (n/a)
(n/a)
room_no char 5
no yes
no
bill_amt float 8 53 (
null)no (n/a)
(n/a)
bill_gst float 8 53 (
null)no (n/a)
(n/a)
pay_amt float 8 53 (
null)no (n/a)
(n/a)
pay_gst float 8 53 (
null)no (n/a)
(n/a)
oc_code1 char 5
no yes
no
oc_code2 char 5
yes yes
yes
oc_code3 char 5
yes yes
yes
anc_type char 2
yes yes
yes
ipa_stat char 2
yes yes
yes
Identity Seed In
crement
-- --- --
---
No identity column defined. (null) (n
ull)
index_name index_description
index_keys
-- ----
- ----
----
--
----
--
i_admission0 nonclustered located on default
ur_no
i_admission3 nonclustered located on default
adm_date
i_admission2 nonclustered located on default
adm_type
(1 row(s) affected)
No constraints have been defined for this object.
No foreign keys reference this table.|||I'd run consistency checks against the database:
DBCC CHECKDB
DBCC CHECCATALOG
DBCC NEWALLOC
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Femmy" <anonymous@.discussions.microsoft.com> wrote in message
news:9BC246D8-38BF-40DE-AF28-341F23C8DB2E@.microsoft.com...
> Hi all,
> I am having problems to rebuild or create a new index at SQL server 6.5.
It is always give me error message:1910 " cannot create more than 250
indexes in one table. While I am only having 5 indexes in this table. I
really don't know what's went wrong since it was alright for all this years.
> I really need help to deal with this problem since the table is the main
transaction in our application system.
> Thanks in advance