<p>I would like to have a nice template for doing this in development. How do I reset an increment identity's starting value in SQL Server?</p>

[{'answer_id': 16977, 'author': 'Ryan Sampson', 'author_id': 1375, 'author_profile': 'https://Stackoverflow.com/users/1375', 'pm_score': 8, 'selected': True, 'text': "<pre><code>DBCC CHECKIDENT('TableName', RESEED, 0)\n</code></pre>\n"}, {'answer_id': 16983, 'author': 'Keith', 'author_id': 905, 'author_profile': 'https://Stackoverflow.com/users/905', 'pm_score': 4, 'selected': False, 'text': '<p>To set the identity to 100:</p>\n\n<pre><code>DBCC CHECKIDENT (MyTable, RESEED, 100)\n</code></pre>\n'}, {'answer_id': 17016, 'author': 'Forgotten Semicolon', 'author_id': 1960, 'author_profile': 'https://Stackoverflow.com/users/1960', 'pm_score': 5, 'selected': False, 'text': '<p>Just a word of warning with:</p>\n\n<pre><code>DBCC CHECKIDENT (MyTable, RESEED, 0)</code></pre>\n\n<p>If you did not truncate the table, and the identity column is the PK, you will get an error when reaching pre-existing identites.</p>\n\n<p>For example, you have identities (3,4,5) in the table already.  You then reset the identity column to 1.  After the identity 2 is inserted, the next insert will try to use the identity 3, which will fail.</p>\n'}]
['https://Stackoverflow.com/questions/16971', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1976/']