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