September 17, 2002 at 7:08 am
Hi all!
I just learned the-hard-way that the SQL server function ENCRYPT has stopped working (right?), so I need to replace it with something.
I do not wish to use pwdencode, to prevent stumbling upon the same problem in future releases.
So, is there any simple way using T-SQL to acomplish the same thing (hash, one way, encryption)? Could SHA or MD5 be written in T-SQL?
Or do you have any suggestions of how to write an SP myself that does this. Would checksum do the job for me?
I cannot install DLL:s or other software since this is run on a shared database server. Also, I do want the encryption to be done in the database, not in ASP/components.
Thanks a bunch!
/Fredrik
September 17, 2002 at 9:31 am
FYI:
I posted this in the security forum as well, and have gotten some response there, so please post any replies there instead.
/Fredrik
September 17, 2002 at 2:21 pm
Pls don't cross post
Steve Jones
September 18, 2002 at 12:27 am
Sorry! But I was not sure where to post.
Perhaps you could clarify the topics a bit more by making sure there are descriptions to all the forums.
I'm not sure if security means security-for-sql-server or security-for-the-apps-you-make-with-sql-server...
/Fredrik
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply