SQL Server

SMTP Inspection

See more SMTP Examples

Examine an SMTP session to view all communications sent to the SMTP server. SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    DECLARE @mailman int
    EXEC @hr = sp_OACreate 'Chilkat.MailMan', @mailman OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @mailman, 'SmtpHost', 'smtp.example.com'
    EXEC sp_OASetProperty @mailman, 'SmtpUsername', 'myUsername'
    EXEC sp_OASetProperty @mailman, 'SmtpPassword', 'myPassword'

    EXEC sp_OASetProperty @mailman, 'SmtpPort', 465
    EXEC sp_OASetProperty @mailman, 'StartTLS', 1

    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT

    EXEC sp_OASetProperty @email, 'Subject', 'This is a test'
    EXEC sp_OASetProperty @email, 'Body', 'This is a test'
    EXEC sp_OASetProperty @email, 'From', 'Alex <alex@example.com>'
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Christoph', 'christoph@example2.com'
    EXEC sp_OAMethod @email, 'AddBcc', @success OUT, 'Victor', 'victor@example3.com'

    --  Generate the MIME that is sent when SendEmail is called
    DECLARE @mimeStr nvarchar(4000)
    EXEC sp_OAMethod @mailman, 'RenderToMime', @mimeStr OUT, @email

    PRINT @mimeStr

    EXEC sp_OAMethod @mailman, 'SendEmail', @success OUT, @email
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mailman, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mailman
        EXEC @hr = sp_OADestroy @email
        RETURN
      END

    EXEC sp_OAMethod @mailman, 'CloseSmtpConnection', @success OUT
    IF @success <> 1
      BEGIN

        PRINT 'Connection to SMTP server not closed cleanly.'
      END

    --  Examine the SMTP session log.

    PRINT '----'

    PRINT 'Smtp Session Log:'
    EXEC sp_OAGetProperty @mailman, 'SmtpSessionLog', @sTmp0 OUT
    PRINT @sTmp0

    --  ---------------------------------------------------
    --  Sample output:
    --  ---------------------------------------------------

    --  MIME-Version: 1.0
    --  Date: Fri, 06 Mar 2026 16:21:00 -0600
    --  Message-ID: <A5DC25990C93EC2676F4FBB2BB3BFA9EB34FF9D3@CHILKAT25>
    --  Content-Type: text/plain; charset=us-ascii; format=flowed
    --  Content-Transfer-Encoding: 7bit
    --  X-Priority: 3 (Normal)
    --  Subject: This is a test
    --  From: Alex <alex@example.com>
    --  To: Christoph <christoph@example2.com>
    --  Bcc: Victor <victor@example3.com>
    --  
    --  This is a test
    --  ----
    --  Smtp Session Log:
    --  220 smtp.example.com ESMTP Amazon WorkMail SMTP Service
    --  EHLO MYCOMPUTER<CRLF>
    --  250-smtp.example.com
    --  250-8BITMIME
    --  250-AUTH PLAIN LOGIN
    --  250 Ok
    --  AUTH LOGIN<CRLF>
    --  334 VXNlcm5hbWU6
    --  YWRtaW5AY2hpbGthdHNvZnQuY29t<CRLF>
    --  334 UGFzc3dvcmQ6
    --  {PasswordOrCredentials}
    --  235 Authentication successful.
    --  MAIL FROM:<alex@example.com><CRLF>
    --  250 Ok
    --  RCPT TO:<christoph@example2.com><CRLF>
    --  250 Ok
    --  RCPT TO:<victor@example3.com><CRLF>
    --  250 Ok
    --  DATA<CRLF>
    --  354 End data with <CR><LF>.<CR><LF>
    --  {388 bytes} <--- The MIME source of the email (examined via RenderToMime) was sent here.
    --  <CRLF>.<CRLF>
    --  250 Ok
    --  QUIT<CRLF>
    --  221 Bye

    EXEC @hr = sp_OADestroy @mailman
    EXEC @hr = sp_OADestroy @email


END
GO