SDU Tools 159 Reset Sequence
SDU Tools are free tools and provide example T-SQL code for SQL Server developers and DBAs. If you work with sequences in SQL Server, you often need to be able to reset the value of a sequence, either back to a starting value of 1, or to a specific next value. The ResetSequence tool does that.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com