Join 3,416 readers in helping fund MetaFilter (Hide)


SQL 2000 Monitoring
March 15, 2005 10:46 AM   Subscribe

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 (4 answers total)
 
Can you clarify your question? I'm still not sure what you're looking to do. "SQL mail" ?

Structured Query Language Mail? What is that?
posted by odinsdream at 11:15 AM on March 15, 2005


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


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


« Older I need help remembering a kids...   |  I am looking to buy a car for ... Newer »
This thread is closed to new comments.