Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

strange ordering in enterprise manager

Status
Not open for further replies.

ikirkland

Programmer
Joined
Feb 27, 2002
Messages
16
Location
GB
I have a table with an identity, which is the primary key clustered and all of a sudden a select * (return all rows option) is bringing the data back not in an incremental fashion. Do I need to run any repair commands on the database, or reindex stuff???

Or even something else??
 
Have you been deleting and inserting rows? If so the space where the rows were deleted will be re-used by later insertions. So the identity values for later inserted rows will be out-of-sequence in the un-sorted display. Not to worry, it is normal.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top