I am facing a problem with identity and my problem is ...
If an identity column exists for a table with frequent deletions, gaps can occur between identity values . I want to remove these gaps mean I want to continue counting from where the gap exits..
mean unwanted gap when deleting a row using identity column
can you suggest something..??
This post has been edited by samforever1989: 04 December 2010 - 10:44 AM