Create a new User

[Stephan Jahrling]

Hello,

How can I create a new user with password for the MS SQL - Server 2000
(and the MSDE) with a SQL - Statement? I use Borland Delphi 5 with the
ADO - Components!

Thanks.

best regards.
Stephan Jahrling

[Anith Sen]

Re: Create a new User

Since you referred to password, I assume you are talking about Server logins
instead of database users. To add a new login you can use: sp_addlogin

For an existing login to add a new user to a database, you can use:
sp_adduser

Please refer to SQL Server Books Online for more details on sp_addlogin &
sp_adduser system procedures along with examples

--
- Anith
( Please reply to newsgroups only )