I have SQL server 2008 R2 I want to send emails to all my registered SQL users but I do not have the Emails function Installed in the management studio SQL I want to know if there is any way to send emails taking the variables in the column:
SELECT Email FROM Table WHERE Email is not NULL
from some script batch, java, Sripts stored procedure or trigger that I can do that function from my database TAKING INTO ACCOUNT that there are more than 30,000 users is that I want to send news to all my users. I want to make it so that it takes 300 per day.
Thank you in advance.