sql server - Decrypt password encrypted using Exec master.dbo.xp_sha1 -

sql server - Decrypt password encrypted using Exec master.dbo.xp_sha1 -

i want decrypt passwords stored in database on sql server 2008 encrypted using exec master.dbo.xp_sha1 @password, @encpassword output .is possible decrypt?

encrypted passwords : xxstgggettebbqyyayujjweee

thanks

xp_sha1 not standard master stored procedure, not included in sql server i've seen, doing quick google came across: http://www.xpcrypt.com/xpho/xp_sha1.htm

as stated in answer/comments in question encrypt passwords on sql server 2008 using sha1 encryption not same thing hashing. sha1 hash, not encryption. encryption can undone, hashing cannot.

the links called out in reply lastly question go through in detail, here several articles around differences between encryption , hashing:

difference between hashing password , encrypting it

http://www.darkreading.com/safely-storing-user-passwords-hashing-vs-encrypting/a/d-id/1269374

please understand there fundamental difference between encrypting , hashing.

if encrypt "password" "123809dsfajsfoiwj" example, knowing key , encryption method, can arrive @ "password" through appropriate decrypt.

using sha1 , hashing "password" there no way ever reverse hashed "jdsfioajd0f98uas" (example) original "password". hashes created same each time given same input, hashes compared hashes "validating passwords". never arrive @ original.

sql-server sql-server-2008 encryption