deencrypt a value in master

Hi fellows,
I would need to know the contains the "password" field but
data appears in hexa.
Is there anyone here be able to show me how can I obtain the value?
select password,* from master.dbo.sysxlogins
where name = 'sa'
order by xdate1 desc
Thanks a lot,Enric wrote:
> Hi fellows,
>
> I would need to know the contains the "password" field but
> data appears in hexa.
> Is there anyone here be able to show me how can I obtain the value?
> select password,* from master.dbo.sysxlogins
> where name = 'sa'
> order by xdate1 desc
> Thanks a lot,
You can decrypt passwords as far as I know. Why do you need to do this?
David Gugick
Imceda Software
www.imceda.com|||Passwords are stored using a one-way hash algorithm and cannot therefore be
decrypted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:9A38467E-5515-4D02-90A6-36C6B22F9202@.microsoft.com...
> Hi fellows,
>
> I would need to know the contains the "password" field but
> data appears in hexa.
> Is there anyone here be able to show me how can I obtain the value?
> select password,* from master.dbo.sysxlogins
> where name = 'sa'
> order by xdate1 desc
> Thanks a lot,
>|||TYPO
You can't decrypt passwords... Dan has it right. They are hashes and
therefore cannot be decrypted.
David Gugick
Imceda Software
www.imceda.com