Readable encryption script ? - SQL Server Forums

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)

Readable encryption script ?

Author

Topic

thiruna
Starting Member

41 Posts

Posted - 2004-05-26 : 05:55:24

Hi,

I want a script which generates readable characters encryption for the key we supply.

DECLARE @key Varchar(10)
DECLARE @encrypted Varchar(50)
EXEC Encrypt_this_key @key, @encrypted OUTPUT
SELECT @output

I would like the script to generate a encrypted key which contains only alphabets and numerics. ( e.g )

EXEC Encrypt_this_key 'thiru', @encrypted OUTPUT

gives something like 'HSykdjdkd30d5KSO2fEK8Dkfhrn7fS4jk3fo7ed4'

Does anyone have this kind of script already.

Many thanks in advance
thiru

Kristen
Test

22859 Posts

Posted - 2004-05-26 : 06:46:42

Haven't used it but there is some stuff at http://wonko.com/xpcrypt/ which might do.

More stuff at http://pajhome.org.uk/crypt/md5/

Kristen