New stored procedures:
Siriussp_msgr_CreateAttachment
Siriussp_msgr_GetAttachment
Siriussp_msgr_SelectPendingMessages
Siriussp_msgr_UpdateStatusCounts
siriussp_msgr_GetStatusCounts
siriussp_msgr_GetMessageStatus
siriussp_msgr_SelectMessages
siriussp_msgr_SubmitMessage
siriussp_msgr_StartRetries
siriussp_msgr_UpdateMessageStatus
siriussp_msgr_SelectPendingMessages
The following stored procedures are available to the user of the SiriusMSAPI:
siriussp_msgr_SubmitMessage
• SubmitMessage creates a unique id for the message and return it to the caller.
siriussp_msgr_GetMessageStatus
• GetMessageStatus returns the numeric value for the message’s current status.
siriussp_msgr_CreateAttachment
• CreateAttachment is called BEFORE SubmitMessage. The ID returned must be passed to SubmitMessage if an attachment is to be included with a message.