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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-02-20 : 07:16:10
|
| Table "auto" (1024 column exist ) is not having any references and contraints.in sp_help it is not showing any indexes on the table. however it has 249 entries in sysindexes , i need to create only 3 index on table. if i try to create non clustered index it throws more than 249 non cluster is not allowed. but i have not created any index on the table...How the entry happened at sysindexes for non cluster....also i generate the same table script and create new instance of the table. now i see only one entry in sysindexes..how that happened...could u all help me out ... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 14:16:12
|
| Did you check it with 'manage index' in em? Does the table have statistics? |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2008-02-22 : 01:01:14
|
| In DBCC SHOW_STATISTICS ( TABLE, TARGET)..In target i have to give index name .. but it does not exist..what i have to do to find that .... |
|
|
|
|
|
|
Noncluster at sysindexes