Script to List Missing Identity Numbers

--Code to Find Missing Identity Values
USE MyDb2
GO
DECLARE @table_name char(9)
SET @table_name = 'employees'
DECLARE @min_id int, @max_id int, @incr_id int
SET @min_id = (SELECT MIN(id) FROM employees)
SET @max_id = (SELECT MAX(id) FROM employees)
SET @incr_id = (SELECT IDENT_INCR(TABLE_NAME)
                 FROM INFORMATION_SCHEMA.TABLES
                 WHERE IDENT_INCR(TABLE_NAME) IS NOT NULL
                 AND TABLE_NAME = @table_name)
CREATE TABLE #u(id INT)
 WHILE (@min_id < @max_id)
   BEGIN
      INSERT INTO #u values (@min_id)
      SET @min_id = @min_id + @incr_id
   CONTINUE
   END
GO
CREATE TABLE #t(id INT )
  INSERT INTO #t
    SELECT id FROM employees
GO
SELECT 'Missing Identity Numbers' 
GO
SELECT DISTINCT id
  FROM #u
    WHERE id NOT IN
     (SELECT id FROM #t)

--select * from #t where id is not null
--select * from #u where id is not null

--DROP TABLE #t
--DROP TABLE #u