Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 script to create a login & password

Author  Topic 

arorarahul.0688
Posting Yak Master

125 Posts

Posted - 2008-09-23 : 11:37:16
how to write a script to create a login & password for a database in sql server 2000.
plz show me the right direction thanks

Rahul Arora
07 Batch
NCCE Israna,


######################
IMPOSSIBLE = I+M+POSSIBLE

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-23 : 11:42:19
have a look at sp_addlogin

http://doc.ddart.net/mssql/sql70/sp_adda_20.htm
Go to Top of Page

NeilG
Aged Yak Warrior

530 Posts

Posted - 2008-09-23 : 11:57:11
sp_addlogin 'LoginNamewanted','PasswordWanted'

**************************
Check Check and double check it's the safest way
Go to Top of Page
   

- Advertisement -