Encrypted Views

Question

Post reply

Encrypted Views

Raghavender Chavva

SSCrazy Eights

Points: 8669
More actions
July 28, 2010 at 12:02 am

#144381

Hi All,
In our database some of the views are in encrypted state.
When we tried to check thier syantax, its saying that the views are encrypted and you cannot watch the.
We have tried to script out them, but no use.
Can any body help in this, how to decrypte them and check its syntax.
Thank You.
Regards,
Raghavender Chavva

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Henry Treftz SSCarpal Tunnel Points: 4207 More actions · Answer 1

There are some scripts out there that claim to do it as well as at least one third party application.

Do a google search on

decrypt sql 2005 stored procedure

And you can find them

Lowell SSC Guru Points: 323518 More actions · Answer 2

i believe when you google as instructed above,you'll finds posts referencing how when you connect via the Dedicated Admin Connection(DAC), everything is decrypted for you, so you could script it that way.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 3

Henry Treftz (7/28/2010)
There are some scripts out there that claim to do it as well as at least one third party application.
Do a google search on
decrypt sql 2005 stored procedure
And you can find them

Tried google but no use....any help please ?

Thank You.

Regards,
Raghavender Chavva

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 4

First google result for me: http://www.mssqltips.com/tip.asp?tip=1046

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 5

Steve Jones - Editor (8/1/2010)
First google result for me: http://www.mssqltips.com/tip.asp?tip=1046

I think I have missed this link......Thanks A Lot for your help, now I am able to decrypt the views.

Thank You.

Regards,
Raghavender Chavva

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 6

wHEN I TRIED THE SAME ITS DELETING THE PROCEDURE WHICH I CREATED

S_Kumar_S SSCrazy Eights Points: 9037 More actions · Answer 7

Yup, this code is not working for atleast SQL Server 2005. instead it delets the proc which you try to decrypt...

So be careful while using it...

Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

crazy4sql SSCoach Points: 19590 More actions · Answer 8

have you tried sp_helptext to read the code.

It should diplay you code if you have permission to run SPs

sp_helptext 'objectname'

----------
Ashish

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 9

Ashish u tried that..

I tried the same example in SQL server 2008 & R2 ..Its deleting the procedure..

S_Kumar_S SSCrazy Eights Points: 9037 More actions · Answer 10

As itold , it deetes the proc. So if u run sp_hlptext, this is wt u will get:

Msg 15009, Level 16, State 1, Procedure sp_helptext, Line 54

The object 'EProc' does not exist in database 'test' or is invalid for this operation.

Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

crazy4sql SSCoach Points: 19590 More actions · Answer 11

sp_helptext......deleting your SP. strange.......never had such experience.....

i just executed it on ss2008 and able to see the code

----------
Ashish

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 12

Ratheesh.K.Nair (8/2/2010)
wHEN I TRIED THE SAME ITS DELETING THE PROCEDURE WHICH I CREATED

Which item did you try? Note that the procedure give is for SQL 2000, but there are some utilities that are linked which work on SQL Server 2005. They cost money, but I don't know of any free decryption tools for SQL Server 2005.

Please don't use "the same" as a pronoun. I know that this can be a common usage for non-native English speakers, but "the same" is not a pronoun. The way you have used it, it is also ambigious. It is not clear what you refer to.

Instead, if you say "I tried the script labled decrypt2k and it deleted my procedure" it becomes clear.

S_Kumar_S SSCrazy Eights Points: 9037 More actions · Answer 13

Abhisek

What I meant was, if you run te code from the link shared by Steve on SQL 2005, i doesn'twork there.

It just deleted the proc. And then if you run sp_helptext, then you get the error.

Of course, how can sp_helptext delet a proc???

Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

S_Kumar_S SSCrazy Eights Points: 9037 More actions · Answer 14

Aybody know of any free utility to decrypt in sq server 2005..

Thanks Steve for clarifiction on using 'the same'. I otenused it 🙂

will try to avoid it now

Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.