Create Log Table

CREATE TABLE [dbo].[ErrorLog](
    [errordate] [datetime] NULL,
    [erroruser] [varchar](30) NULL,
    [errormachine] [varchar](30) NULL,
    [errormessage] [text] NULL,
    [errorversion] [varchar](16) NULL,
    [errorapp] [varchar](75) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[ErrorLog] ADD  CONSTRAINT [DF_Table_1_when]  DEFAULT (getdate()) FOR [errordate]
GO

ALTER TABLE [dbo].[ErrorLog] ADD  CONSTRAINT [DF_Table_1_username]  DEFAULT (user_name()) FOR [erroruser]
GO

ALTER TABLE [dbo].[ErrorLog] ADD  CONSTRAINT [DF_ErrorLog_errormachine]  DEFAULT (host_name()) FOR [errormachine]
GO

ALTER TABLE [dbo].[ErrorLog] ADD  CONSTRAINT [DF_ErrorLog_errorapp]  DEFAULT (app_name()) FOR [errorapp]
GO