Dbcc
How i can rearrange the index using dbcc command
ie i need to arrange the values from 1 to n with out any break
Thanks
[201 byte] By [tony_parekkaden] at [2007-11-18 19:07:45] 
I'm having one id field which is of identity type.
How i can rearrange the index using dbcc command
ie i need to arrange the values from 1 to n with out any break
Thanks
# 1 Re: Dbcc
I think you want to fill the gaps created by deleting some records.ok DBCC can't do this.
SET IDENTITY INSERT ON statement allows you to insert records in and give a value of Identity column.
there is a sample in SQL Books online about this .. just search for IDENTITY INSERT.
hspc at 2007-11-9 13:37:22 >
