Re: Newbee password question

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 04/30/04


Date: Thu, 29 Apr 2004 20:26:51 -0500

SQL Server stores passwords using a one-way hash. Although you could
retrieve the hashed data from sysligns, the value is meaningless to your
application.

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"JRE" <nomail@all> wrote in message
news:%232kk9yiLEHA.268@TK2MSFTNGP10.phx.gbl...
> Is there a way to retreive passords for SQL Server authenticated users
from
> a system table? I'd like to retreive the passwords for a handfull of SQL
> Server users and place them in a database table (for application
purposes).
> I've looked for functions and stored procedures in the Books On Line, but
> came up empty.
>
> Thanks,
> Joe
>
>


Relevant Pages

  • Re: Newbee password question
    ... fetching them. ... > SQL Server stores passwords using a one-way hash. ... >> Is there a way to retreive passords for SQL Server authenticated users ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server sa Password reset
    ... There is no password policies for SQL Server authenticated users. ... "Suresh Nadesan" wrote in message ... > Microsoft SQL Database Running in the Same Server. ...
    (microsoft.public.sqlserver.server)