I would like to be able to use the stored procedure 'aspnet_Membership_CreateUser' directly through T-SQL code (instead of going through .Net wrappers) because I need to automate the creation of hundreds of users.
aspnet_Membership_CreateUser has among others the following parameters: @Password, @PasswordSalt, @PasswordAnswer. I assume that the @Password and @PasswordAnswer have to be encrypted using the @PasswordSalt
I have been unable to find documentation that explains 1. how to create the passwordsalt or where to retrieve it from2. how to hash/encrypt the password and the security answer. Is there another SP that does that?
Any help would be greatly appreciated. Roberto
...
Go to the complete details ...