What I am trying to do is  call a stored procedure or method that will create a new user.  

What I am planning to do is use this stored procedure in a SQL script to create a bulk import of users data into a local Database table, then drop that to a query window and create that new table in my remote database my site database. 

the idea is to load up a table which is created from a .CSV , drop that and move it to my remote DNN site database.  Then do an inset or call the relevant stored procedure to extract the new user values from the table i just created and create a user for every record.

ending up with a result of 100's of registered members on my site.

Some questions, should i just do an insert or should i use a procedure , I know that when i look at the users tables their is a password salt so I am a bit unclear as to which method to use.   

Thanks for the reply,

I solved this issue myself, i wrote a few SQL scripts that targeted the correct tables in the DNN Database, I studied the database, tables , sp's , views and then it was just a matter of walking through the process of inserting the page data into the tabs table, setting the permisssions, then a script to add the correct modules and then set its properties and.

Everything worked out well , when i really analysed the database of the framework and the tables related to the 3rd party modules it was just a matter of writing the SQL script to insert the data i needed, its really powerful way of working with the framework, now that im working with 100's of users and the 1000's of pages manging the process of adding modules and data , content etc to the whole site is just a matter of running a sql script.

Im now integrating those SQL scripts into a Desktop application that interfaces with my remote site.  So when i want to run a poll for every politician its a matter of loading the interface, adding the parameters and executing the script. 

I've used John Mitchell's Import User script is, and it's awesome! I just used it export my users from DNN2 and import them into DNN5. This was the SQL I wrote to export my userbase...

SELECT
'<User><Username>' + u.Username + '</Username>',
'<Email>' + u.Email + '</Email>',
'<FirstName>' + u.FirstName + '</FirstName>',
'<LastName>' + u.LastName + '</LastName>',
'<Password>' + u.Password + '</Password>',
'<Unit>' + u.Unit + '</Unit>',
'<Street>' + u.Street + '</Street>',
'<City>' + u.City + '</City>',
'<Region>' + REPLACE(u.Region,'<Not Specified>','') + '</Region>',
'<PostalCode>' + u.PostalCode + '</PostalCode>',
'<Country>' + u.Country + '</Country>',
'<Telephone>' + u.Telephone + '</Telephone></User>'

FROM UserPortals up INNER JOIN Users u ON u.UserID = up.UserId WHERE up.PortalId = 5