Hi,
I'm trying to create some sample data in my database that has the ASP.NET Security tables installed. For the most part, I can use the stored procedures to create the records I need (aspnet_Applications, aspnet_Users, aspnet_Membership, aspnet_Roles, and aspnet_UsersInRoles). However, the password and the password salt are encrypted apparently by the API before it gets to the stored procedure. Is there any way I can create these values inside the stored procedure?
I'm using straight SQL and custom stored procedures to create the data. This is the only thing holding me up. Unfortunately, some tables that I created require records in the security tables. The only way I can get these records in the database is to use the API, which has to be done via an application. I would just like to know if there is a way I can do it with straight SQL.
Thanks,
Kevin
...
Go to the complete details ...