xxx

SELECT db2.name AS sequence_name, db2.current_value as UAT_value, db2.current_value as PROD_value, CONCAT('ALTER SEQUENCE [dbo].[Counter] RESTART WITH ', cast(db2.current_value as varchar(50)), ';') as ALTERATION_SQL

FROM northwind1.sys.sequences AS db1

left join northwind2.sys.sequences db2 on db1.name = db2.name

order by sequence_name