[dba-SQLServer] Where does it go?

Mackin, Christopher CMackin at quiznos.com
Fri Oct 8 11:18:41 CDT 2004


It adds the login to the Server in EM look under Security->Logins.

Then you can use sp_adduser to assign that login as a user in specific database.

-Chris Mackin

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W.
Colby
Sent: Friday, October 08, 2004 9:53 AM
To: SQLServer
Subject: [dba-SQLServer] Where does it go?


If I do the following:

EXECUTE sp_addlogin @loginame =  'DataEntry', @passwd = 'ASDFG'

Where is this login name stored?  
How can it be tested?  
I set up my system to use Windows Login.  Can I perform a "SQL SERVER LOGIN"
somehow to test that this login "took"?

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list