list account passwords

Question

list account passwords

finance_teacher

SSC Eights!

Points: 855
More actions
October 20, 2004 at 6:50 pm

#162525

What SQL code will give me a list of all users and their password ?
Example:
JohnDoe - Pass543t
JaneDoe - 15dg3t6

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

TriggerMe SSChampion Points: 11752 More actions · Answer 1

Natively(SQL Server) speaking, I don't think that is possible. The closest thing you can do is use the PWDENCRYPT() function to compare passwords against.

Kindest Regards,

Greg Milner SSCrazy Points: 2425 More actions · Answer 2

Check this out. It's about as close as you will get. Give you all logins and their encrypted pwds. Good for moving logins from one server to another.

Migrating Logins To Another Server

Regular Columnist : Gregory Larsen

Posted: 09/30/2003

http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp

G. Milner

noeld SSC Guru Points: 96590 More actions · Answer 3

To be honest I hope you don't find such thing

* Noel