Change all Mail Users to external notification

Version 1
    Question

    How to set all users to use external notifications.

    Answer

    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.

    *******************************************

    Environment

    ITBM Console Mail Manager.