Automate SQL login account creation?

Hello. Does anyone know if it's possible to write a stored procedure or
script that will create new SQL Server logins, passwords, and assign role
membership based on a table that contains all of the potential users? I was
hoping this would be possible for it to go through a table and automate this
instead of creating all of the SQL login accounts manually. Thanks in
advance.
JYou can use several system stored procedures below example.
EXEC sp_addlogin 'loginid', 'password', 'default database'
"J"?? ??? ??:

> Hello. Does anyone know if it's possible to write a stored procedure or
> script that will create new SQL Server logins, passwords, and assign role
> membership based on a table that contains all of the potential users? I w
as
> hoping this would be possible for it to go through a table and automate th
is
> instead of creating all of the SQL login accounts manually. Thanks in
> advance.
> J
>
>|||Thanks for your quick reply Hongju :-)
"hongju" <hongjujung@.hotmail.com.korea> wrote in message
news:D35AB19B-86E3-4A9E-A8E2-5CE0C157BC70@.microsoft.com...[vbcol=seagreen]
> You can use several system stored procedures below example.
> EXEC sp_addlogin 'loginid', 'password', 'default database'
>
> "J"' ? ':
>

Auto Number Data Type?

Is there a data type like Access's auto number that will automatically assign a record a number? I transfered a database from Access 2000 to SQL 2000 and it did not preserve the autonumber datatype.Identity is the SQL Server equivalent to the Access autonumber.|||When I open a table in design view and I change a datatype I do not see Identity in the list.|||Identity is property not a data type.
Chose a INT type for instance, then (in the bottom of the design screen - columns panel) specify if that's an identity column, the seed and increment eventually.

Originally posted by aaronshover
When I open a table in design view and I change a datatype I do not see Identity in the list.|||Thanks, that helped. I got it working now.