You can get the loginname and the encrypted password from sys.syslogins. You can not pull out a logins password in plain text though.
select name, password from sys.syslogins.
If you need to copy a login then MS has a proc that you can use for that as well. Details at link below.
Last Wiki Answer Submitted: May 21, 2012 2:50 pm by Colin Smith845 pts.