RE: [Emerald] (2.5.255)Mail site and using different domain then the set billing group. When will i

Rudy Komsic ( (no email) )
Fri, 19 Feb 1999 17:35:24 -0500

Yes I had this problem and I created this procedure to ignore the Emerald
domain structure (which is based on the MBR and not on the Service level)

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

CREATE PROCEDURE VerifyMailUser @username varchar(32), @domain varchar(32),
@esid integer AS
Select Login, Shell, EMail, d.MailDomain, Password, HomeDir