How to spot breaks in sequences

How to spot breaks in sequences

It's often useful to know where breaks in a sequence occur in your data (if you are looking for missing IDENTITY columns in a table, missing invoices in your billing system, and so on) There is no built-in functionality that SQL Server has to address the problem, but it's not difficult to code your own.

http://www.easy-sql-server.com/index.asp?subject=bseq&page=1

Great Tip. Overly segmented though - too many unnecessary pages to navigate through.

Thanks.

Nathan H.O.
Moderator
SQL-Server-Performance.com

Yes, a good script though. It's good to know none of our tables have any breaks in their identity fields.

Tom Pullen
DBA, Oxfam GB