Don't forget about permissions. See below:
CREATE PROCEDURE VerifyMailUser @username varchar(32), @domain varchar(32), @esid integer AS
Select Login, Shell, EMail, d.MailDomain, Password, HomeDir