1. Three columns were added in the guests table: notifymsg (varchar(100)), notifydate (datetime) and notify_sp (bit).

2. A stored procedure (sproc) was created: siriussp_SendEventMessagePlusDetails. This sproc works like the existing siriussp_SendEventMessage but also appends the sp_log.details text as Additional Information: to the message body.

3. Five activity types were added to the act_type table: 6-"Notify Guest On Sale", 7-"Notify Guest On Reservation", 115-"Notify Guest Validated At Salespoint", 116-"Notify Guest Validated At Scanner/Gate", 117-"Notify Guest Subsequent Validated". Each of these have a storedproc column value of "siriussp_SendEventMessagePlusDetails" which triggers a notification message, including details, to the proper recipients.