To get password fron sql server?
How to get SQL server's login and password?pls: i know query for get it.
Software/Hardware used:
Software
Software/Hardware used:
Software
ASKED:
May 10, 2012 10:51 AM
UPDATED:
May 21, 2012 2:51 PM
Answer Wiki:
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.
http://support.microsoft.com/kb/246133
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
