Errors

CREATE TABLE [dbo].[ErrorLog](
   [CreateDate] [datetime] NOT NULL DEFAULT getdate(),
   [SpID] [smallint] NOT NULL DEFAULT @@SPID(),
   [Username] [varchar](50) NOT NULL DEFAULT suser_sname(),
   [Message] [nvarchar](4000) NOT NULL
)
ON [PRIMARY]
END
CREATE NONCLUSTERED INDEX [IDX_ErrorLog_CreateDate] ON [dbo].[ErrorLog]
(
   [CreateDate] ASC
)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IDX_ErrorLog_Username] ON [dbo].[ErrorLog]
(
   [Username] ASC
)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_Error_I]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_Error_I]

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_Error_I]') AND type in (N'P', N'PC'))
BEGIN
   EXEC dbo.sp_executesql @statement = N'
CREATE PROCEDURE [dbo].[usp_Error_I]
@V_Message nvarchar(4000)
AS
BEGIN
-- =============================================
-- Author:
-- Description: Log Errors
-- =============================================
SET NOCOUNT ON;
-- Insert statements for procedure here
INSERT INTO [dbo].[ErrorLog]([Message]) VALUES (@V_Message);
END
'
END