Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-19 : 09:29:02
|
| Mark writes "I understand using CDO/CDONTS to send mail from SQL, but is there any way to pass alerts through CDO instead of using MAPI/SQL Mail? In our environment we have MS Outlook installed and open on the SQL Server to pass alerts. This requires that someone with permissions to the MAPI mailbox be logged in to the server at all times. If the server shuts down in the night we have no way to log the server back in except using NT auto-logon. Auto-logon is a huge security risk in my mind..." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-09-19 : 10:17:12
|
| You can specify a job to execute for each alert. The job can send the email via cdo ...Jay White{0} |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-19 : 15:09:25
|
| Are you using Outlook 2002 ? If not then there should be no need to have outlook running. It should be irrelavent whether the server console is logged in. Are you saying SQLMail won't work otherwise ??If you are using Outlook 2002 downgrade to Outlook 2000. If you are using Outlook 2000 you have a setup issue. Have a look at[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886[/url]specificaly Question 11. Here's a few more links[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311231[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281293[/url][url]http://support.microsoft.com/servicedesks/webcasts/wc091301/wcblurb091301.asp[/url]HTHJasper Smith |
|
|
|
|
|
|
Send alerts using SMTP instead of SQL Mail