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