RE: decrypt function in SQL Server 2000
From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 11/17/04
- Next message: Jasper Smith: "Re: Security Problem with AD Group in SQL Server Security Logins area"
- Previous message: Dan Guzman: "Re: Sql Security ?QL"
- In reply to: jzhou: "decrypt function in SQL Server 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 17 Nov 2004 05:39:08 -0800
The others have explained why you shouldn't use this undocumented feature. To
answer your original question, there is no corresponding decrypt SP because,
despite the name, pwdencrypt isn't in fact an encryption function. pwdencrypt
generates a hash (not a very secure one apparently) so you can't actually
"decrypt" it.
-- David Portas SQL Server MVP --
- Next message: Jasper Smith: "Re: Security Problem with AD Group in SQL Server Security Logins area"
- Previous message: Dan Guzman: "Re: Sql Security ?QL"
- In reply to: jzhou: "decrypt function in SQL Server 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
