SQL Mail

Definition of SQL Mail in The Network Encyclopedia.

Sponsor: Geeky T-Shirt: No, I Will Not Fix Your Computer (Amazon)

What is SQL Mail?

A utility in Microsoft SQL Server 6 that can send messages through the built-in Messaging Application Programming Interface (MAPI) of Microsoft Windows NT.

SQL Mail messages can be

  • Short strings of text
  • The output of a query
  • An attached file

By using SQL Mail extended stored procedures, you can send messages in response to events such as the following:

  • SQL Server generates an alert.
  • A performance monitor threshold is exceeded.
  • A scheduled task succeeds or fails.
NOTE

SQL Server 7 uses two services for sending mail:

  • MSSQLServer Service:
    Processes mail for mail stored procedures

     

  • SQLServerAgent Service:
    Has its own mail capabilities that are separate from SQL Mail