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 |
|
mrock
Starting Member
23 Posts |
 Posted - 2007-01-31 : 14:48:52
|
| Our company does not allow microsoft office to be installed on our server. I have been trying to get Agent mail (Alerts) to work using Outlook Express. (I had it working using Microsoft Outlook 2003, but they removed it.)I need to know a correct install and setup to make Outlook Express work. (We also are not allowed to have non-expiring password accounts, so I have it setup using my network account). I don't know if I will have to change its password every 30 days as I have to do for Sql Server, and Agent services. |
|
|
mrock
Starting Member
23 Posts |
Posted - 2007-02-23 : 10:16:37
|
| I did download Db Maint SMTP Alerter. The test message works, but I get an error trying to send an actual alert (violation of primary key) I sent the error message to SQLDev (XPSMTP.DLL) as follows:I am not sure how DB Maint uses XPSMTP, but none of these error message seem directly related to xp_smtp_sendmail.Can you send mail when you just invoke the XP directly?GertD@SQLDev.Net --------------------------------------------------------------------------------Sent: Tuesday, February 20, 2007 7:28 AMTo: Bugs@SQLDev.NetSubject: SQLDev.Net problem report: Hi, I downloaded XPSMTP.DLL to use with Db Maint SMTP Alerter because we are not allowed to install outlook on our Microsoft SQL Server 2000 running on Windows 2003.I get an error "Error from New SqlClient Data Provider: Line 12 Incorrect syntax near 'PK_tblCenterPlanAmPm' ( which is the name one of my SQL Server tables) I have an alert to notify me when I attempt to insert a duplicate record (violate the primary key), and uses XPSMTP.DLL to read/email the alert. The Alert: Error 2627, Severity: 14, State: 1 Violation of PRIMARY KEY constraint 'PK_tblCenterPlanAmPm' Cannot insert duplicate key in object 'tblCenterPlanAmPm' What can I do to fix this? Thanks, Does anyone know the fix. I saw a related article in Experts Exchange, but don't have a member account, so could not see if the solution was related.MIke |
 |
|
|
|
|
|
|
|
AgentSqlMail using Outlook Express