Hello all,
Have you ever wondered what happened to the numbers' sequence having gaps?
If you have a table with a numeric columns (non-identity) that may have been used for ID, or product number, etc, then there are times that you as a developer would like to know if there are any gaps in the sequence and if those might have been caused and generated by a bug or a faulty application code.
Here is a simple way of determining that.
The script in here will accept ANY fully qualified table name, the 4 part naming of remote server and 3 part naming if local server that you know, and the column name and viola.
http://msdn.microsoft.com/en-us/library/ms187879.aspx
You will get a list of the gaps. Either single numbers, or range of numbers.
Hope this can be helpful.
enjoy
JohnE
