Just to note that using a GUID as a primary key might not be a good idea if the index is created as a clustered index due to the random values given to GUIDs, and their length at 16 bytes.

NEWSEQUENTIALID() can be used in conjunction with GUIDs if they are to be the clustered index.