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

Decision trees, DMX and CONTAINS (T-SQL)

I would appreciate answers to the following doubts I have regarding Decision trees, CONTAINS and using CONTAINS in a DMX query:

1. Does MS decision tree work only off equality/inequality conditions for the nodes? Is it possible to use a predicate as the branch criteria for a node?

2. Can the T-SQL predicate CONTAINS(...) be used in a DMX query? I need to check if a column-value is a substring of another column and create an intermediate column that will enable me to construct a decision tree with the phrase-present/absent branch.

3. Can CONTAINS(...) be used in a select clause? Like -

SELECT CONTAINS(JAT.column1, '"Good day"')

FROM JustAnotherTable;

4. Does CONTAINS(...) support both arguments to be column references? Or, is it mandatory that the pattern (argument #2) has to be a literal string or a variable? E.g.: I need to know the validity of the following expression -

SELECT * FROM JustAnotherTable JAT

WHERE CONTAINS(JAT.column1, JAT.column3);

The decision tree split conditions are based on equality/inequality conditions for categorical attributes and numeric/range comparisons for continuous values - we don't do arbitrary predicates.

CONTAINS is not supported in DMX.