Can i create a user account in SQL Server without use the
Entreprise Manager? How? Use TSQL? or VB?
Thanks and regards,
Wenkie Leong
Using TSQL - suggest you look in Books Online for the following system stored procedures:
sp_addlogin
sp_grantdbaccess
sp_addrole
sp_addrolemember
Or read the whole section, which is in the contents under
<Administering SQL Server> <Managing Security> <Creating Security Accounts>
Obviously you can write your own stored procedures encapsulating these, and call it/them from VB
Regards
AJ
"wenkie leong" <wenkie...@planetone-asia.com> wrote in message news:232e01c27402$44c8eb90$37ef2ecf@TKMSFTNGXA13...
look up in sql book online for more details.
"wenkie leong" <wenkie...@planetone-asia.com> wrote in message
news:232e01c27402$44c8eb90$37ef2ecf@TKMSFTNGXA13...