Hi,
    I want to create a new user in Windows domain and at the same time,after the creation is successful, the same user should also be created in the SQL Server database.
    It's and urgent problem and facing this problem for two days. if any one can help me ,pls telll me how it will be solved.....
:)
 Iteamic

View this links on how to create a user in command line

http://www.is-it-true.org/nt/atips/atips34.shtml
http://windows.about.com/library/tips/bltip238.htm

also look at xp_cmdshell in books on line. This procedure allows you to use the command line in a stored procedure.

xp_getnetname returns the name of the network for the SQL server.





Sal