i have a few tables that were created in mssql 2005 server. due to my inexperience at the time, the tables were created without a primary key or unqiquely identifying column. 

how can i add a column with a unique id (auto incrememnt?) to a table with existing data (around 600k rows)?

i need this to be a Primary key so that i can start using SQL Analysis services. 

Many thanks, 

Adam