I was really pissed when I realized that iSync had disappeared after upgrading to OS X Lion. Suddenly, I had no mean to synchronize my cellular phone with my computer. I find this type of attitude very rude from Apple. Well, by chance I did not really upgrade. In fact, I installed OS X Lion […]
Permission problem to run msdb.dbo.sp_send_dbmail
I needed to be able to send emails from a stored procedure using something like EXECUTE msdb.dbo.sp_send_dbmail @recipients=’address@domainname.com’, @subject = ‘Test email’, @body = ‘Test email body’ The solution was to add the user I was using to run the above query to the msdb database and to assign the role DatabaseMailUserRole to the user: […]