For the sql server mail the Xp_smtp_sendmail has been used. So first that dll should be downloaded.

To setup the xp_smtp_sendmail:

1)     For...

Hello Larsen,

While executing the scripts , I came to know I am can not run the script as there is a problem with my server name .

My server name...

Hello Larsen,

Thank you very much for the script . I will be testing it today.

I got a doubt if I can use the SMTP server mail, which I am...

Hello Larsen,

Thank you very much for the script . I will be testing it today.

I got a doubt if I can use the SMTP server mail, which I am...

Hi,

Also if there are 2 servers , the 1st server can check the status of the 2nd server agent and mail when it fails and vice-versa.

Let me know if there...

Hello

I am not getting output when I run that query in the sql analyzer.

What should I do , should I make any changes.

Thanks

But for the sqlserver agent to be used, I need to set up the sqlmail which requires the exchange on the server which has some problems. So I have been...

Thanks for the command.

Can you let me know , how to write the command for xp_sendmail.

Thanks