Change all Mail Users to external notification

Version 1

    How to set all users to use external notifications.


    update tps_user set tps_notify_method=2

                   where tps_email_address is not null

                   and tps_notify_method <> 2

                             and tps_deleted <> 1



    This should be run by your database administrator and tested against a test copy of your database before applying live. When you apply to the live database, please ensure that no-one else is logged in and that a backup of the database has been taken. In the event of any problems you should restore from the backup copy.



    ITBM Console Mail Manager.