• I think I found an answer to my own question. I need to create an Event-Notification (what sql agent Alerts use under cover)...create a QUEUE,SERVICE,ROUTE, EVENT NOTIFICATION...or if not an EVENT, then Issue a message (after rollback) to the queue from my logon trigger and have the queue ACTIVATION kick off an email or something.

    might also work for notifying the user with a spcific message rather then the generic trigger error that they get now when I Rollback.