Does anyone know what is the best (and preferably easiest (-:) way to setup SQL Mail without having to install Outlook on the Database Server and leaving it open? I want to be able to create an operator that will receive mails when jobs fail, etc. But i hate to have Outlook installed and running on the server.
So: What are my alternatives? And which advantages/disadvantages do they have? And do you have links to a place where I can find info on how to set it up?
The server is running windows 2003 server enterprise edition and SQL Server 2000 SP4. We do have an exchange server (but on another machine).