On the SharePoint 2010 MySite EditProfile.aspx, there are settings for Email Notifications:
[x] Notify me when someone leaves a note on my profile. [x] Notify me when someone adds me as a colleague. [x] Send me suggestions for new colleagues and keywords. Select which e-mail notifications you want to receive.
Unfortunately, they default to having all three options checked. I would like to set different defaults for all users, present and future and have them explicitly Opt in to these.
Is there any way to do that? The idea of just executing a SQL UPDATE to set Property 5040 to 7 fails because that property doesn't exist by default in the database, and if SharePoint can't find it in the database it defaults to 0 (=all checked).