SQL Server 2000 and Lotus Domino

[wond]

Create a link or to sending an e-mail notifications from an SQL Server 2000 Database to a mail server like Domino - any ideas

[MikeParent]

Eek, well SMTP would be your best bet, but it requires the SMTP gateway task to be running on the domino server. Can you expand on what it is you're trying to do?

[wond]

Just to Expand - I will be running Lotus Domino and SQL Server 2000 on the same server. SQL will be used as a Back-end, while Domino will be the mail server. The aim is to send e-mail notifications from SQL Server based enterprise systems to Domino accounts, based on database events: INSERT, UPDATE, DELETE (possibly using triggers)

[MikeParent]

Hmmm, try this?

http://www.example-code.com/sql-server-send-mail.asp

[MikeParent]

THe SMTP Listener task will need to be running for this to work...