Good deal!

Sounds like you need to make the primary key field an identity field so it will automatically generate a unique field for you on insert.

- Did you sync the sids when moving the database?  If you did not sync the sids in sysusers and master..syslogins this will cause serious issues. 

- Did you name the new...