====== Reset identity ======
  * Identity property in MSSQL server auto increment column value. 
  * When we remove rows identity column continues with incerment value, but sometimes we need reset identity to predefined value.
  * We have three choices:
    - DBCC CHECKIDENT
    - Drop and Add the column
    - Drop and Create the table

<code mssql>
DBCC CHECKIDENT ( <table name>,RESEED,<new value>)
</code>