LISTING 1: Using UTC in a DEFAULT CONSTRAINT

CREATE TABLE dbo.TrackRecordInsertion
( RecordID             int                     NOT NULL      IDENTITY,
  InsertedWhen      smalldatetime   NOT NULL
         CONSTRAINT TrackRecordInsertionInsertedWhenDefault
                   DEFAULT getutcdate() )
GO
INSERT INTO dbo.TrackRecordInsertion
   DEFAULT VALUES
GO
SELECT * FROM dbo.TrackRecordInsertion
GO