February 20, 2008 at 11:23 pm
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...
February 21, 2008 at 12:10 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply