Admin User Account from Front -end Interface

Hi all,
I would like to create User Account(mean user can admin
user account) from Front-end (using VB 6.0), pls give How
to, sample program or manual how to.
TIAYou can create a new SQL Server login account using sp_addlogin:
EXEC sp_addlogin 'AdminAccount', 'AdminPassword'
Or you can grant an existing windows account access to SQL Server with
sp_grantlogin:
EXEC sp_grantlogin 'MyDomain\AdminAccount'
If the account is to be a server administrator, you can add it to the
sysadmin server role:
EXEC sp_addsrvrolemember 'AdminAccount', 'sysadmin'
or
EXEC sp_addsrvrolemember 'MyDomain\AdminAccount', 'sysadmin'
Note that you shouldn't use a sysadmin login for routine application access.
See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
<thankch@.hotmail.com> wrote in message
news:045b01c3c9c3$6b3384d0$a301280a@.phx.gbl...

quote:

---

> Hi all,
> I would like to create User Account(mean user can admin
> user account) from Front-end (using VB 6.0), pls give How
> to, sample program or manual how to.
> TIA
>

---