SQL 2000 Monitoring

March 15, 2005 10:46 AM

I am trying to implement SQL mail fonctionnality for monitoring purpose under win2k / sql2k, only problem is to be configurer properly it must first obtain its parameter from Microsoft Mail API (MAPI) thru an already configured mail account, these are production servers and i don't feel too good about installing Outlook or Outlook express just to get an account configured so i can use this fonctionnnality. is there a way around this ? I am aware of several monitoring solution offered by third parties and i accept proposition (please no astroturfin') but I want to get that build in feature to work first.. anyone ? Thanks Selfsck
posted by selfsck to Computers & Internet (3 answers total)

Best answer: SQL Mail is horrendous for requiring a MAPI profile

here is a better solution
HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
posted by patrickje at 12:10 PM on March 15, 2005

I believe it's sending mail from triggers/stored procedures in SQL Server. on preview, what patrickje saidl
posted by mrg at 12:12 PM on March 15, 2005

Response by poster: mrg has it right, From MMC snap it's in Support service then SQL mail. used to monitor and send alarm acording to certain treshold...

odinsdream: here's more details from Microsoft
http://support.microsoft.com/default.aspx?scid=kb;en-us;311231
posted by selfsck at 12:59 PM on March 15, 2005