CREATION OF USER

[Guest_imported]

I'd like to know, the way of create an user in
Microsoft SQL SERVER, using only code.

I know how to do it, over visual interface, but I need to do it under code, ok?

thanks, please give you hurry!!

 

[tlbroadbent]

If you are refering to SQL code, look in SQL Books Online for details on using these system stored procedures.

sp_addlogin - add a SQL authenticated login
sp_grantlogin - add a Windows authenticated login
sp_grantdbaccess - allow a login to use a database
sp_adduser - allow a login to use a database Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.