Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2010-11-15 : 02:20:25
|
| hello everybody.i would like to know if there is any way to decrypt the passwords in sql server.i mean i should be able to pull out the exact password which i have stored in the database through encryption. |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-11-15 : 04:09:52
|
| The best way to handle those encryption and decryption is in front end !Even you want to do in Mssql server, the simplest way is casting as varbinary.insert into <table_name> (password_column) values (cast('passsword' as varbinary(50)))Select cast (password_column as varchar(50)) from <table_name>Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
michael.appleton
Posting Yak Master
160 Posts |
Posted - 2010-11-15 : 04:15:34
|
| Why would you want to decrypt something that is encrypted? If it was easy, wouldn't that defeat the object of having it encrypted in the first place? |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-15 : 05:42:56
|
| we dont know what comes to our use and when.learning something new is not wrong. |
|
|
|
|
|
|
DECRYPTING PASSWORD