A couple years back I modified our LRP_NSCAN_SEND_EMAIL procedure to add some extra stuff like appending constituency codes to the email that the active monitoring sends out when patrons arrive. I've been asked to change this up a little bit by adding some new functionality like showing 12 month giving and #years as a Subscriber inside of the email. So to do this I went in and modified the LRP_NSCAN_SEND_EMAIL procedure. However these new changes did not reflect in the emails that were sent out tonight as patrons arrived. It is still using the custom logic I built a couple years back.
So evidently, LRP_NSCAN_SEND_EMAIL is not where the email text is being built anymore? We are running the NSCAN email utility and are not running NSCAN monitoring through the SQL job as in the past. Can anyone shed some light? Tomorrow night I will have a chance to use a Profiler trace during the "door open" period but it's bothering me that I can't figure this out. Any ideas?
Thanks.
-doug