Has anyone done something like this?
For reference, here is a sample of my SQL INSERT trigger:
Code: Select all
DECLARE @domainName nvarchar(64)
DECLARE @smtpUserName nvarchar(64)
DECLARE @emailAddress nvarchar(256)
DECLARE @emailPassword nvarchar(256)
SELECT @domainName = [domainname] from inserted
SELECT @smtpUserName = [smtpusername] from inserted
SELECT @emailAddress = [email] from inserted
SELECT @emailPassword = [epass] from inserted
INSERT INTO [MailEnable].[dbo].[AUTH] (UserName, Password, Account, Status, Rights)
VALUES (@emailAddress, @emailPassword, @domainName, '1', 'USER')
INSERT INTO [MailEnable].[dbo].[MAILBOX] (Postoffice, Mailbox, RedirectStatus, Status, SizeLimit, Size)
VALUES (@domainName, @smtpUserName, '0', '1', '-1', '0')