In an Identity column, i'm having for example 5 records. I've used delete statement to delete all the records. after that i've tried to insert a new record. so this record will be my first record. but the Identity column value gives me 6. but it should start again from 1. <BR><BR>anyone can help me by rectifying this problem.<BR><BR>TA<BR>Raghu.