title: How to auto Shift primary keys to start from 1 again
body: <p>I am using a table created like:</p>
  
  <pre><code>CREATE TABLE [dbo].[Tag](
      [TagID] [int] IDENTITY(1,1) NOT NULL,
      [Value] [varchar](200) NOT NULL,
      [TagCount] [varchar](200) NULL,
   CONSTRAINT [PK_Tag] PRIMARY KEY CLUSTERED 
  (
      [TagID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  </code></pre>
  
  <p>I can never insert a primary key it just auto continues from the last one. So if my last entry had a primary key of 72 then the next entry will be 73.</p>
  
  <p>Now my problem is when i delete a entry. Say now i deleted entry's 3-7 my database will have entry's stored 1,2,8,9 ect.</p>
  
  <p>Is there a stored procedure i could run after my delete to just <strong>auto shift</strong> my primary keys to be <strong>ordered from 1 again?</strong></p>