converting a string into a password varbinary field.

Hi,
I have a table that saves user information, name, password etc.
How do I convert the user entered password into a varbinary datatype?convert(varbinary(10), passwordfield) ?
Is this what you are looking for?
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ryan McAuley" <ryan.mcauley@.sympatico.ca> wrote in message
news:TtZ0e.10317$JK1.876077@.news20.bellglobal.com...
> Hi,
> I have a table that saves user information, name, password etc.
> How do I convert the user entered password into a varbinary datatype?
>

converting a string into a password varbinary field.

Hi,
I have a table that saves user information, name, password etc.
How do I convert the user entered password into a varbinary datatype?convert(varbinary(10), passwordfield) ?
Is this what you are looking for?
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ryan McAuley" <ryan.mcauley@.sympatico.ca> wrote in message
news:TtZ0e.10317$JK1.876077@.news20.bellglobal.com...
> Hi,
> I have a table that saves user information, name, password etc.
> How do I convert the user entered password into a varbinary datatype?
>sqlsql

converting a string into a password varbinary field.

Hi,
I have a table that saves user information, name, password etc.
How do I convert the user entered password into a varbinary datatype?
convert(varbinary(10), passwordfield) ?
Is this what you are looking for?
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ryan McAuley" <ryan.mcauley@.sympatico.ca> wrote in message
news:TtZ0e.10317$JK1.876077@.news20.bellglobal.com. ..
> Hi,
> I have a table that saves user information, name, password etc.
> How do I convert the user entered password into a varbinary datatype?
>

Convert Password hash to clear text

I have sql server password hash table. How can i decrypt these hash
values to get password details in SQL.
THanks
A hash cannot be decrypted because different source values can yield the
same hash value.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mubin The DON" <mubin.shaikh@.gmail.com> wrote in message
news:1163581072.931026.168830@.b28g2000cwb.googlegr oups.com...
>I have sql server password hash table. How can i decrypt these hash
> values to get password details in SQL.
> THanks
>

Convert Password hash to clear text

I have sql server password hash table. How can i decrypt these hash
values to get password details in SQL.
THanksA hash cannot be decrypted because different source values can yield the
same hash value.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mubin The DON" <mubin.shaikh@.gmail.com> wrote in message
news:1163581072.931026.168830@.b28g2000cwb.googlegroups.com...
>I have sql server password hash table. How can i decrypt these hash
> values to get password details in SQL.
> THanks
>

Convert Password hash to clear text

I have sql server password hash table. How can i decrypt these hash
values to get password details in SQL.
THanksA hash cannot be decrypted because different source values can yield the
same hash value.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Mubin The DON" <mubin.shaikh@.gmail.com> wrote in message
news:1163581072.931026.168830@.b28g2000cwb.googlegroups.com...
>I have sql server password hash table. How can i decrypt these hash
> values to get password details in SQL.
> THanks
>