CREATE TABLE [dbo].MyTable ( [PK] uniqueidentifier ROWGUIDCOL NOT NULL , [UID] [int] NULL , [Changed] [datetime] NOT NULL ) ALTER TABLE [dbo]. MyTable WITH NOCHECK ADD CONSTRAINT [DF_ MyTable _PK] DEFAULT (newid()) FOR [PK], CONSTRAINT [DF_ MyTable _Changed] DEFAULT (getdate()) FOR [Changed], CONSTRAINT [PK_ MyTable] PRIMARY KEY CLUSTERED ( [PK] ) ON [PRIMARY]Best wishes.