Sometimes its desireable to bulk-update user settings. These are are settings found under the "Settings > User preferences" menu. Most of the settings here are stored in the HelpMaster database in the "tblUserSettings" table and follow a simple "settingname=value;settingname1=value;settingname2=value" format. You can see the individual settings on the "User settings" tab of the User preferences screen.
For example, you might have just changed email systems from CDO Sys and now use Microsoft Exchange, and Outlook profiles.
In HelpMaster, there are 2 settings that control this.
Although there is no way to bulk-update each staff member's user settings via the HelpMaster interface, you can do this via the database directly using the SQL "update" command.
Update tblUserSettings
Set Settings = 'EmailProfile=Outlook;EmailProfilePassword=;EmailSystem=0;' + Cast(Settings as Varchar(MAX))
This statement will add these settings to the start of the settings data and the next time you log on to HelpMaster, these will be applied.
As always, when doing any sort of direct database update, please make a backup first. Remember, there is no undo with databases. Once you've applied a script, it's done. Your only "undo" is a database restore.