By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

MSSQL Equivalent to MySQL ENCRYPT/DECRYPT

P: 6
Hi all. I'm having to convert a database over from MySQL to MSSQL 2000.

The problem I'm encountering is that there's a password field that is using ENCODE and DECODE to set and retreive the password, and I'm unable to find an equivalent to this in MSSQL.

So, my question is:
Is there an equivalent to ENCODE/DECODE in MSSQL or is there a standard function a DBA would use that duplicates this functionality. If there's nothing of the sort, then what would you recommend to be the best way to go about this without having to ask all your users to reset their passwords?

Thanks.
Sep 29 '08 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
Try these.



--- CK
Sep 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.