title: Create Umbraco Member using T-SQL
body: <p>I'm trying to create an Umbraco Member using a SQL Server stored procedure instead of the GUI.</p>
  
  <p>Using the SQL Server Profiler I can see that there is a function I can use:</p>
  
  <pre><code>exec sp_executesql N'INSERT INTO [cmsMember] ([nodeId],[Email],[LoginName],[Password]) VALUES (@0,@1,@2,@3)',
                     N'@0 int,@1 nvarchar(4000),@2 nvarchar(4000),@3 nvarchar(4000)',
                     @0=1052, @1=N'test2@email.nl', @2=N'Test2',
                     @3=N'HMMB0498bIiVQ+EoO3ywJQ==6TdcRwNTt/MqaxS1O/ZiQ3906Vd3GcVfgiNHGFWBiTw='
  </code></pre>
  
  <p>Except the nodeId is not unique. Because a member is linked to a node. </p>
  
  <p>I already created a stored procedure to create an Umbraco user and it just needed 2 inserts queries. But it seems like that an Umbraco member needs 10 inserts.</p>
  
  <p>Is it even possible to create a member this way? </p>