To reset the identity seed in SQL Server after deleting records, use the DBCC CHECKIDENT command. For example, if your table is named MyTable, you can run:
DBCC CHECKIDENT (‘MyTable’, RESEED, 0);
This command resets the identity seed to 0, so the next inserted record will start with 1 (or the defined increment). If you want the identity to start at a different value, replace 0 with your desired seed. Ensure no active constraints or dependencies will be affected. Use this carefully in production environments to avoid conflicts with existing data.