bulk_reseed.sql

-----------reseeder-----
DECLARE @sql VARCHAR(MAX) = ''

SELECT @sql = @sql + 
    'DBCC CHECKIDENT (' + QUOTENAME(TABLE_NAME) + ', RESEED, 0);'+CHAR(13)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA = 'dbo'
AND OBJECTPROPERTY(OBJECT_ID(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)), 'TableHasIdentity') = 1
AND EXISTS (SELECT 1 FROM sys.dm_db_partition_stats WHERE OBJECT_ID = OBJECT_ID(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)) AND row_count = 0)
print(@sql)