How to Encript Password in SQL 2000

  • Hi all,

    I need to encrypt password when i save it in my database and also i need to know decrypt password when it retrieve from database..but i dont know how i do it.im using MS-SQL 2000 database sever.tell me how i do this

    Thanks,

    Harsha

  • Unless there is some compelling need to be able to retrieve the actual password, just encrypt it when you store it, then the next time the password is entered, encrypt that using the same algorithm, then compare the result with the value stored in the database. You can search for one way encryption/hashing routines and get some decent information,

  • Could you please post SQL Server 2000 questions in the SQL Server 2000 forums next time?

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

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