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 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 :)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/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_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 tablenam
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 Scale 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 Increment
-- --- ---
No identity column defined. (null) (null)
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=djq&as_ugroup=microsoft.public.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 :)