title: SQLSERVER: How to alter an existing table int primary key to become an identity column?
body: <p>My database has a table with thousands of records. The primary key is an integer. There's a lot of foreign key constraints associated with this column.</p>
  
  <p>I want to change this column to become an identity key. What's the best way to do it? I also need to send this update to our clients installations. </p>
  
  <p>Bonus points for an answer that works in Sql Server 2000.</p>