| 2lazybutsmart 2002-09-17, 7:13 am |
| A1- Well i've never seen sp_who2. But I've had quite and aquaintence with sp_who. sp_who stored proc provides information about current SQL Server users and processes.
A2- sp_addlogin takes 6 parameters, but only 3 are important. i.e loginname, password, and default database. You have to specify the loginname parameter. password parameter will default to NULL, and defdb parameter will default to master, if not specified otherwise.
Examples,
1- (Only login name, password = NULL, defdb=master)
EXEC sp_addlogin cocolocopolo
----------------------------------
2- (Login name and password, defdb=master)
EXEC sp_addlogin cocolocopolo, 'coco'
-------------------------------------
3- (Login name and password and defdb)
EXEC sp_addlogin cocolocopolo, 'coco',
CocoDB
---------------------------------------
cheers,
2lazybutsmart |