title: SQL to create .Net Membership Provider users
body: <p>I have a SQL script that creates users in in my database.
  It uses the .Net membership stored procs. </p>
  
  <p>At this point it works fine.</p>
  
  <p>The only issue is that the passwords are <strong>saved clear text.</strong> What should I change here to they are <em>salted/encrypted</em> (Not sure what term to use here)</p>
  
  <pre><code>GO
  
  DECLARE @return_value int,
    @UserId uniqueidentifier
  
  
  EXEC @return_value = [dbo].[aspnet_Membership_CreateUser]
    @ApplicationName = N'Theater',
    @UserName = N'sam.sosa',
    @Password = N'mypassword',
    @PasswordSalt = N'eyhKDP858wdrYHbBmFoQ6DXzFE1FB+RDP4ULrpoZXt6f',
    @Email = N'sam@Simple.com',
    @PasswordQuestion = N'Whats your favorite color',
    @PasswordAnswer = N'Fusia',
    @IsApproved = 1,
    @CurrentTimeUtc = '2010-03-03',
    @CreateDate = '2010-03-03',
    @UniqueEmail = 1,
    @PasswordFormat = 0,
    @UserId = @UserId OUTPUT
  
  SELECT @UserId as N'@UserId'
  
  SELECT 'Return Value' = @return_value
  
  GO
  </code></pre>
  
  <p>thanks!</p>