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: 323482 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

MysteryJimbo

SSC-Insane

Points: 24203

November 22, 2011 at 6:42 am

#1411436

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

PaulB-TheOneAndOnly SSC Guru Points: 66773 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 Shirbad 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: 1004494 More actions · Answer 5

Gail Shaw

SSC Guru

Points: 1004494

November 22, 2011 at 6:51 am

#1411450

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