Resetting SQL Server Identity Columns

Microsoft SQL Server identity columns provide a useful way to automatically generate consecutive numeric values for identifying rows. During software testing, IDs may be generated and then deleted. Afterwards, you may want to reset the number sequence.