Decrypting WITH Encryption User Functions...

...it's possible without any third party application?

I need to recover some encrypted user functions but the sources have been
lost long time ago, someone can help me?
--

Lav."Laverio" <darthmoul@.despammed.com> wrote in message
news:br7rlk$2l8$1@.newsreader.mailgate.org...
> ...it's possible without any third party application?
> I need to recover some encrypted user functions but the sources have been
> lost long time ago, someone can help me?

Actually in the past I think I've heard of folks watching it go through the
Profiler.

> --
> Lav.|||http://www.securiteam.com/tools/6J00S003GU.html

--
David Portas
----
Please reply only to the newsgroup
--

"Laverio" <darthmoul@.despammed.com> wrote in message
news:br7rlk$2l8$1@.newsreader.mailgate.org...
> ...it's possible without any third party application?
> I need to recover some encrypted user functions but the sources have been
> lost long time ago, someone can help me?
> --
> Lav.sql

Decrypting Encrypted Views/Sp/Functions.....?

Hi all,
As all of you are aware you can Encrypt your Triggers/Stored Procedures/Views And Functions
in Sql Server with "WITH ENCRYPTION" clause.recently i came across a Stored procedure on the Net that could reverse and decrypt all Encrypted objects.i personally tested it and it really works.That's fine (of course for some body)
Now i want to know is it a Known Bug for Sql Server 2000 and is there a permanent solution for Encrypting mentioned objects.

Thanks in advance.
Best Regards.

Yes. No.|||

There are huge enhancements with Encrption/Decrption in SQL2005, you may take a look at this article:

http://www.sqlservercentral.com/columnists/mcoles/sql2005symmetricencryption.asp

decrypt function in SQL Server 2000

I know that there are undocumented encryption function, such as:
pwdencrypt
pwdcompare
anyone know what is the decrypt function in SQL Server 7.0/2000. If you know
any, please provide syntax and some simple examples.
Thanks a lotHi,
THose function are undocumeted and may not be available in next version.
refer the below site:-
http://www.activecrypt.com/
Thanks
Hari
SQL Server MVP
"jzhou" <jzhou@.discussions.microsoft.com> wrote in message
news:0DC77411-9710-4A06-A502-EE1DC61DAE54@.microsoft.com...
>I know that there are undocumented encryption function, such as:
> pwdencrypt
> pwdcompare
> anyone know what is the decrypt function in SQL Server 7.0/2000. If you
> know
> any, please provide syntax and some simple examples.
> Thanks a lot|||To add to Hari's response, undocumented functionality can change between
versions or even service packs and thus break your code. Avoid using
undocumented stuff in production.
Hope this helps.
Dan Guzman
SQL Server MVP
"jzhou" <jzhou@.discussions.microsoft.com> wrote in message
news:0DC77411-9710-4A06-A502-EE1DC61DAE54@.microsoft.com...
>I know that there are undocumented encryption function, such as:
> pwdencrypt
> pwdcompare
> anyone know what is the decrypt function in SQL Server 7.0/2000. If you
> know
> any, please provide syntax and some simple examples.
> Thanks a lot|||The others have explained why you shouldn't use this undocumented feature. T
o
answer your original question, there is no corresponding decrypt SP because,
despite the name, pwdencrypt isn't in fact an encryption function. pwdencryp
t
generates a hash (not a very secure one apparently) so you can't actually
"decrypt" it.
David Portas
SQL Server MVP
--