[dbo].[Forum_EmailQueue

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@EmailFromAddress	nvarchar(100)	200
@FromFriendlyName	nvarchar(100)	200
@EmailPriority	int	4
@EmailHTMLBody	ntext	16
@EmailTextBody	ntext	16
@EmailSubject	nvarchar(50)	100
@PortalID	int	4
@QueuePriority	int	4
@ModuleID	int	4
@EnableFriendlyToName	bit	1
@DistroCall	ntext	16
@DistroIsSproc	bit	1
@DistroParams	nvarchar(50)	100
@ScheduleStartDate	datetime	8
@PersonalizeEmail	bit	1
@Attachment	nvarchar(50)	100

SQL Script

CREATE PROCEDURE dbo.[Forum_EmailQueue_TaskAdd]
@EmailFromAddress nvarchar(100),
@FromFriendlyName nvarchar(100),
@EmailPriority int,
@EmailHTMLBody ntext,
@EmailTextBody ntext,
@EmailSubject nvarchar(50),
@PortalID int,
@QueuePriority int,
@ModuleID int,
@EnableFriendlyToName bit,
@DistroCall ntext,
@DistroIsSproc bit,
@DistroParams nvarchar(50),
@ScheduleStartDate datetime,
@PersonalizeEmail bit,
@Attachment nvarchar(50)
AS
    INSERT INTO dbo.Forum_EmailQueue_Tasks
        (EmailFromAddress, FromFriendlyName, EmailPriority, EmailHTMLBody, EmailTextBody, EmailSubject,
        PortalID, QueuePriority, ModuleID, EnableFriendlyToName, DistroCall, DistroIsSproc,
        DistroParams, ScheduleStartDate, PersonalizeEmail, Attachment)
    VALUES
        (@EmailFromAddress, @FromFriendlyName, @EmailPriority, @EmailHTMLBody, @EmailTextBody, @EmailSubject,
        @PortalID, @QueuePriority, @ModuleID, @EnableFriendlyToName, @DistroCall, @DistroIsSproc,
        @DistroParams, @ScheduleStartDate, @PersonalizeEmail, @Attachment)

SELECT SCOPE_IDENTITY()

GO