CREATE TABLE ErrorLog ( lsn INT NOT NULL IDENTITY PRIMARY KEY, dt DATETIME NOT NULL DEFAULT(GETDATE()), errid INT NOT NULL, comments VARCHAR(100) NOT NULL ) CREATE TABLE T1(col1 INT NOT NULL PRIMARY KEY) CREATE TABLE T2(col1 INT NOT NULL PRIMARY KEY) INSERT INTO T1 VALUES(1) INSERT INTO T2 VALUES(1) GO