how to decrypt a view( how open encrypted view)

• mak12

  Ten Centuries

  Points: 1037

  More actions

  November 22, 2011 at 7:36 am

  #252326

  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

  --I don't use TFS of source control.

  --the property of view under option Encrypted is true how change to Falase

  regards

  very urgent

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  November 22, 2011 at 7:40 am

  #1411507

  Please don't create duplicate threads...

  http://www.sqlservercentral.com/Forums/Topic1210091-391-1.aspx

• September 7, 2018 at 1:51 am

  This was removed by the editor as SPAM