title: Changing primary key value for a database row
body: <p>I am using SQL Server Management Studio and I want to change an auto increment primary key value of a table row, with a different value. SQL Server Management Studio after opening the table for edit, shows this field grayed for all rows, of course.</p>
  
  <p>Is it possible? I want to use the number of a row we deleted by mistake, therefore it's valid (there is no conflict with other primary key values) and - most important of all - the next row added in the DB should have an intact auto incremented value.</p>
  
  <p>Thanks.</p>
  
  <p>EDIT: losing the link with other table records on this PK is not an issue for this row. We can restore it manually. </p>