Hi I found this site and was hoping somebody could help me out. I've got a large table (about 500,000+ rows), and I need to set the primary key to autoincrement, the problem is when I attempt this in the management studio it time-outs. So my next attempt was to create a new table with the same columns but set the PK to autoincrement, and then do a insert into 'blah' select * from 'original blah'. This worked fairly well, but still took 20+ minutes to copy the data into the new table. Has anybody got any ideas on how to reduce the time it takes to copy data between the two tables? Or any other ideas for that matter, I've tried to look into bulk inserts, but I'm not sure if that will help. Any help would be greatly appreciated, thanks!