Also this script verifies that the actual user is active too. If the user
has been set inactive, then no mail will be relayed to the mailbox and
returned as a NON-Existant E-Mail address.
if exists (select * from sysobjects where id =
object_id('dbo.VerifyMailUser') and sysstat & 0xf = 4)
drop procedure dbo.VerifyMailUser
GO
CREATE PROCEDURE VerifyMailUser @username varchar(32), @domain varchar(32),
@esid integer AS
Select Login, Shell, EMail, d.MailDomain, Password, HomeDir