Post reply

Example Code : Please explain...

  • February 11, 2005 at 11:30 am

    #185071

    CONVERT(VARBINARY(64), pwdEncrypt(@strUserPassword)),

    I am came accross this in an example database code, it was sitting in an INSERT Statement.

    I cant find any explanation for this "pwdEncrypt"

    The example database has no functions of this name, BOL has nothing. If there is stuff for SQL server un documented, where can I find a reference for this secret stuff ??

  • February 11, 2005 at 12:01 pm

    #541865

    PWDEncrypt() is an undocumented and unsupported built-in SqlServer function.

    There is no guarantee that it will exist in future versions of SqlServer.

  • February 11, 2005 at 12:08 pm

    #541870

    Just to complete, it is used to encrypt data. I think sql uses it mostly to encrypt the passwords, but we can use it as well.

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

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