How to insert a primary key??

Resolved - thank you.

If you are in SQL Server 2005 you are in luck just do ALTER TABLE SET IDENTITY, I think you should know IDENTITY is not a field but property of the field. Now if you are in SQL Server 2000 you have to do it manually through Enterprise Manager and script it and execute it if needed. The code in the link below is for SQL Server 2005 try it if you are in 2000 it may work. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms190273.aspx