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: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
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