add 1000 users...

hi
how can I add 1000 users (user_name, password) from txt, csv file to
aspnetdb.mdf database?
thanks
ereszBCP the data into a table. Then construct an sp_adduser statement for each
row in the table and dynamically execute it. If it is 2005, you would use a
CREATE USER command instead of sp_adduser.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<eresz@.op.pl> wrote in message
news:1145538712.170169.133870@.j33g2000cwa.googlegroups.com...
> hi
> how can I add 1000 users (user_name, password) from txt, csv file to
> aspnetdb.mdf database?
>
> thanks
> eresz
>|||> If it is 2005, you would use a CREATE USER command instead of sp_adduser.
And if eresz's intent is to add application users, the appropriate aspnetdb
procs are dbo.aspnet_Membership_CreateUser and perhaps
dbo.aspnet_UsersInRoles_AddUsersToRoles.
Hope this helps.
Dan Guzman
SQL Server MVP
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:OwiO$YPZGHA.3400@.TK2MSFTNGP02.phx.gbl...
> BCP the data into a table. Then construct an sp_adduser statement for
> each row in the table and dynamically execute it. If it is 2005, you
> would use a CREATE USER command instead of sp_adduser.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> <eresz@.op.pl> wrote in message
> news:1145538712.170169.133870@.j33g2000cwa.googlegroups.com...
>