Noncluster at sysindexes

  • 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 in 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...

  • Please don't post multiple threads for the same problem

    Replies to the following thread please - http://www.sqlservercentral.com/Forums/Topic458367-5-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply