Hi

I am using SQL Server 2005.
I created a table and i defined an identity column. So whenever i enter any values to my table, the values in identity column keep on increasing like 1,2,3,4,5 on its own.
but when i delete, say, row no. 5 and insert a row again after deleting, the numbering in identity column will be like 1,2,3,4,6.
but i want it it to be 1,2,3,4,5 again. I hope i have made myself clear.

does anyone have the solution for this!!!!

Thanks!!!