Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shastryv
Posting Yak Master
145 Posts |
 Posted - 2001-08-13 : 16:23:49
|
Can any one tell me why sp_helpindex shows several indexes though there is only one index on the table. When i use Enterprise manager it shows only one index..Any idea..is it a bug ..do I need to apply latest service pack ?Here is the output showsIX_tbl_ncf_bo _WA_Sys_Deal_No_2902ECC1 _WA_Sys_fwddate_2902ECC1 _WA_Sys_deal_type_2902ECC1 _WA_Sys_RegionID_2902ECC1 _WA_Sys_CompID_2902ECC1 _WA_Sys_To_Include_2902ECC1 _WA_Sys_SvcChoice_2902ECC1 _WA_Sys_UtilityID_2902ECC1First one is actual index that I created, remaining  Shastry.V |
|
|
|
|
|
Strange Indexes