Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Noncluster at sysindexes Expand / Collapse
Posted Wednesday, February 20, 2008 11:23 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2008 11:51 PM
Points: 41, Visits: 119
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...
Post #458371
Posted Thursday, February 21, 2008 12:10 AM



Group: General Forum Members
Last Login: Today @ 8:18 AM
Points: 44,621, Visits: 42,380
Please don't post multiple threads for the same problem

Replies to the following thread please -

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

Post #458376
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse