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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Encryption

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-05-25 : 08:44:11
sushant writes "Hello,

I am having MS SQL database. In there is one table for user information. Password column is in Encrypted form. When i do query then it gives me result in Encrypted form. Please tell me SQL query or select statement to view the password."

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-05-25 : 10:01:03
If the encryption was SQL Server ENCRYPT() function, there is no corresponding decrypt function provided.
Go to Top of Page

vganesh76
Yak Posting Veteran

64 Posts

Posted - 2004-05-25 : 23:45:52
All u can to do is encrypt and update the database.

Enjoy working
Go to Top of Page
   

- Advertisement -