1:  SET ANSI_NULLS ON

   2:  GO

   3:  SET QUOTED_IDENTIFIER ON

   4:  GO

   5:  CREATE TABLE [dbo].[SendMail](

   6:      [i] [int] IDENTITY(1,1) NOT NULL,

   7:      [Date] [datetime] NOT NULL,

   8:      [ToAddr] [nvarchar](256) NOT NULL,

   9:      [Subject] [nvarchar](500) NOT NULL,

  10:      [Body] [nvarchar](max) NOT NULL,

  11:      [Error] [nvarchar](max) NULL

  12:  ) ON [PRIMARY]

  13:  GO

  14:   

  15:  SET ANSI_NULLS ON

  16:  GO

  17:  SET QUOTED_IDENTIFIER ON

  18:  GO

  19:  Create procedure [dbo].[AddMailError]

  20:  @i int,

  21:  @Error nvarchar(max)

  22:  as

  23:  update [SendMail] set [Error]=@Error where I=@i

  24:  GO

  25:   

  26:  SET ANSI_NULLS ON

  27:  GO

  28:  SET QUOTED_IDENTIFIER ON

  29:  GO

  30:  create procedure [dbo].[AddMail]

  31:  @ToAddr nvarchar(256),

  32:  @Subject nvarchar(500),

  33:  @Body nvarchar(max)

  34:  as

  35:  INSERT [SendMail]([Date],[ToAddr],[Subject],[Body])

  36:  VALUES (GetDate(), @ToAddr, @Subject, @Body)

  37:  select SCOPE_IDENTITY() as MailId

  38:  GO