The following T-SQL shows how to reset a tables identity auto increment back the last available number. This may be useful if you have removed a bulk amount of data…
The following T-SQL shows how to reset a tables identity auto increment back to 1. This may be useful if you have cleared all data from a table and want…