var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Auto e-mails
I have a SQL server though a hosting company and I am trying to send autoemails using xp_sendmail. The permissions were set and I used the following command to test it.
sql stored procedure'
It gave me a message saying "Mail sent" but there none in my e-mail box.
How do I set yp the SQL Mail server, right? Please help. I don't know what is happening.
Re: Auto e-mails
Have you checked whether the Mail Service has been turned on and the machine has MS Outlook installed(And it has to work)?
And an Outlook need to have mail configured using the same account the SQL Server Agent runs as.
Insead of all that, you could use CDO to send mail, which eliminates the need to have Outlook installed.
Check out this: