title: How to reset identity in Table
body: <p>My scenario is... I create Table as(id identity(1,1) not null,name varchar(500),category varchar(50))... i try to insert values.. displays has (1,'sede','diabetes') and it goes has 1,2,3. But when i delete the total content.. once again insert it starts with 4,5,6...</p>
  
  <p>I don want this type of inserting...When content i deleted it should start from 1,2,3..</p>
  
  <p>How can i achieve this.. i need it in stored procedure.. Any idea..</p>