Just to let people know, I usually use something like the following

DECLARE @new_id AS UNIQUEIDENTIFIER

SET @new_id = NEWID()

INSERT INTO

([primary_key]) VALUES (@new_id)

SELECT @new_id

I find that I get this problem if I rename a table from one name to another as Enterprise Manager does not change the keys/constraints. I find the best way...