I'm trying to create a stored procedure to create, update, or delete users.  I have an external database with userid, password (unencrypted!), firstname, lastname, email, (bool)isAuthorized fields.  I am writing my stored procedure using a visual studio 2005 database project.  I want to schedule this procedure to run every 15 minutes on a table created by a trigger that I've written.  Users may become authorized, unauthorized, change passwords, added, or deleted from the table.

My problem is this:  I have located stored procedures in the dnn database for AddUser, UpdateUser, DeleteUser, but none of these accept a password as a parameter.  I also found stored procedures aspnet_membership_createuser that has password as a field, but also has passwordSalt as a field (which I'm not an encryption expert by any means).

Is it possible to write a stored procedure in c# where I can populate a datastructure with the fields I mentioned above and add or update users from the stored procedures in the database?  Do I need to run BOTH the AddUser stored procedure AND the aspnet_membership_createuser procedure?  Am I going about this in the complete wrong way?

Yes, but as it turns out we'll not be using SQL 2005, so the CLR proc is out the window.  Thanks for your advice.