I’m making a T-SQL Trigger for automatically creating an email account for hMailServer when a new user register in DNN and also create the user, the servers and the folders for the DNN module WebMail Pro. I need the Username, the Password and the UserId (the int UserId from table Users, not the Uniqueidentifier).

My problem is that if I create the insert trigger on table Users, the record in table aspnet_Membership (for the password) isn’t created yet and if I create the trigger on aspnet_Membership, I can’t get the UserId from table Users as it looks like this record isn’t created then…

Does somebody know on which table the trigger could be on so I can get Username, Password and UserId simultaneously?

Thanks!

Staffan
Sweden