SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'dbo.cftroubleshoot') AND OBJECTPROPERTY(id, N'IsUserTable') = 1 CREATE TABLE dbo.cftroubleshoot ( id int IDENTITY (1, 1) NOT NULL , EventName varchar (100) NOT NULL , ServerName varchar (100) NOT NULL , StartTime datetime NOT NULL , EndTime datetime NULL , DurationMs int NULL , Status varchar (100) , ScriptName varchar(200) , Notes text NULL ) CREATE CLUSTERED INDEX IX_cftroubleshoot ON dbo.cftroubleshoot(StartTime, EventName) ALTER TABLE dbo.cftroubleshoot ADD CONSTRAINT PK_cftroubleshoot PRIMARY KEY (id) INSERT INTO cftroubleshoot ( EventName ,ServerName ,StartTime ,ScriptName ,Notes ) VALUES ( , ,getDate() , , ) SELECT @@IDENTITY AS newID UPDATE cftroubleshoot SET EndTime = getDate() ,DurationMS = ,Status = ,Notes = WHERE id =