Re: Encrypting & Decrypting

From: Mark Broadbent (nospamplease_mark.broadbent_at_virgin.net)
Date: 07/09/03 

Date: Wed, 9 Jul 2003 10:06:48 +0100

great. I wont bother giving you the links now. 

-- 
BR,
Mark Broadbent mcse+i, mcdba
_________________________
"Raghunandan H.J" <raghu@grassrootssys.com> wrote in message
news:923601c345d9$41ff8370$a401280a@phx.gbl...
> thanks kt,
> yes definitely i will take care of saving from next time.
> now i have learnt how to decrypt form google.
> thanks for ur guidence
> raghu
>
> >-----Original Message-----
> >Object encryption in sql server is really more object
> obfuscation rather
> >than encryption. You can pretty easily do a search on
> google or otherwise
> >and find tools (free/shareware tools) that can decrypt
> procedures. The SQL
> >team knows about this. I won't give a direct tool but
> they are out there and
> >I've used them....
> >
> >In the future it might not be so easy. Good lesson
> learned now...make sure
> >you save your code.
> >
> >    Try "decrypt sql server stored procedures" on google
> >
> >hth,
> >kt
> >
> >-- 
> >Please reply only on the newsgroups! Include dml/ddl,
> when possible.Thanks
> >Kimberly L. Tripp
> >President, SYSolutions, Inc. www.SQLSkills.com
> >Principal Mentor, Solid Quality Learning
> www.SolidQualityLearning.com
> >
> >
> >"RaghunandanH.J" <scienty77@hotmail.com> wrote in message
> >news:0cf701c3453d$48914f30$a301280a@phx.gbl...
> >> Hello Mark,
> >> Thank you.
> >> But it happened very mucu accidentally and 'With
> >> Encryption' blindly has made me to thought that there
> will
> >> be someting for Decrypting. But I have done all
> possibles
> >> to get it. But in vein.
> >> If possible pls help me out.
> >> --raghu
> >>
> >>
> >> >-----Original Message-----
> >> >Im sorry to tell you that you needed to take a 'copy'
> of
> >> the code before
> >> >encryption since they cannot be decrypted. (at least
> >> officially). You could
> >> >probably find out how to do this on the internet (I
> dont
> >> have my links to
> >> >hand unfortunately -I shall try to dig them out
> tonight).
> >> >
> >> >-- 
> >> >BR,
> >> >
> >> >Mark Broadbent mcse+i, mcdba
> >> >_________________________
> >> >"RaghunandanH.J" <scienty77@hotmail.com> wrote in
> message
> >> >news:84b101c34531$c7acf1e0$a401280a@phx.gbl...
> >> >> Hello Microsoft family member/s.
> >> >> I was looking out for protecting the SP's written in
> SQL
> >> >> server 2000, when my friend suggested me to use
> >> Encrypted
> >> >> in the beginning of the query. It did.
> >> >> But now I want to  see the normal coding back, as I
> have
> >> >> written few big cursors, which are not  opening. I
> get
> >> a
> >> >> message every time i try to open the query "
> >> >> ---------------------------
> >> >> Microsoft SQL-DMO
> >> >> ---------------------------
> >> >> Error 20585: [SQL-DMO]/****** Encrypted object is not
> >> >> transferable, and script can not be generated.
> ******/
> >> >> ---------------------------
> >> >> OK   [<-- BUTTON]
> >> >> ---------------------------"
> >> >>
> >> >> But I need to decrypt the query immediately so tht I
> can
> >> >> further use it. Can you please help me.
> >> >>
> >> >> regards
> >> >> raghu
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >