how to dcrypt a view

Question

Post reply

how to dcrypt a view

mak12

Ten Centuries

Points: 1037
More actions
November 22, 2011 at 6:37 am

#248325

I script view as CREATE to New Query Editor window .....I got error(property textHeader is not avilable for view '[dbo].[vwxy]'. this property may not exist for this object, or may not be retrievable due to insufficient access rights. This text is encrypted.
--I am sys admin for the database, how i can open this view or how can i change encryption
very urgent

Viewing 9 posts - 1 through 8 (of 8 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

try connecting via the Dedicated Admin Connection:

http://msdn.microsoft.com/en-us/library/ms189595.aspx

I believe all objects are decrypted for you when connecting via the DAC

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!

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 2

You may also find this is a bug in the scripter and sp_helptext will help you.

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 3

mak12 (11/22/2011)
I script view as CREATE to New Query Editor window .....I got error(property textHeader is not avilable for view '[dbo].[vwxy]'. this property may not exist for this object, or may not be retrievable due to insufficient access rights. This text is encrypted.
--I am sys admin for the database, how i can open this view or how can i change encryption
very urgent

Take a look at: http://www.devlib.net/decryptsql.htm

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

mak12 (11/22/2011)
I script view as CREATE to New Query Editor window .....I got error(property textHeader is not avilable for view '[dbo].[vwxy]'. this property may not exist for this object, or may not be retrievable due to insufficient access rights. This text is encrypted.
--I am sys admin for the database, how i can open this view or how can i change encryption
very urgent

This situation can be easily been avoided if you had Source Control Process in place (like VSS, TFS etc.). If you are not able to get the view definition with sp_helptext(), you should hack SQL server (never ever recommended). Also, there are 3rd Party Tools available to decrypt encrypted DB objects.

sp_helptext [ @objname = ] 'name' [ , [ @columnname = ] computed_column_name ]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Redgate SQL Prompt (professional version) can do this.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

mak12 Ten Centuries Points: 1037 More actions · Answer 6

Under property of a view, under option Encrypted is TRUE how to change to false so that i can access the view.

Also is there was to get it from master db?

sqlpadawan_1 SSCommitted Points: 1571 More actions · Answer 7

We've used this in the past, not as good as Red Gate, but it's free.

http://www.devart.com/dbforge/sql/sqldecryptor/

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 8

sqlpadawan_1 (11/22/2011)

We've used this in the past, not as good as Red Gate, but it's free.

http://www.devart.com/dbforge/sql/sqldecryptor/%5B/quote%5D

It adds weight in tool if it's FREE. 😀

Thanks for sharing the information.