AtvSoftware » Products » Xp_pop3 Extended Stored Procedure For MS SQL

« Return To Products //

Xp_pop3 Extended Stored Procedure For MS SQL

Version: 1.0

Requirements: All Windows Platforms

File Size: 40 KB

License: Free to Try

The extended stored procedure xp_pop3 makes accessing a POP3 email boxes very easy from your MS SQL Server. Using this procedure will enable you to build a powerful email processing system based on the MS SQL Server.

exec master.dbo.xp_pop3
    'server',
    'username',
    'password',
    'command',
    message_id

Where:

'server'
- The name of POP3 server.

'username'
- The email account.

'password'
- The password.

'command'
- One of the following commands:

READ
    - Read the message.

READ_TOP
    - Read the message header only.

READ_TOP_DEL
    - Read the message header only and delete the message from the email box.

LIST
    - Read the message ID and size of the message (in octets).

DEL
    - Delete the message from the email box.

'message_id'
Is a positive number when:
message_id = 0 - 'command' affect to all of the messages in the email box.
message_id > 0 - 'command' affect to the message with ID = message_id.