Encrryption on views, how to search ?

• Digs

  SSCertifiable

  Points: 7333

  More actions

  July 7, 2005 at 2:58 pm

  #167448

  HI,

  I have a heap of views, I have turned encryption ON on some of them, is there a SELECT statement I can use on system table that will give me a list of views that I have encrypted, cause I have forgotten which ones i did (ha) !

  Thanks

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  July 7, 2005 at 3:09 pm

  #572094

  Select O.name from dbo.SysObjects O inner join dbo.SysComments C on O.id = C.id where C.Encrypted = 1 and O.XType = 'V'

• Digs

  SSCertifiable

  Points: 7333

  More actions

  July 7, 2005 at 3:15 pm

  #572098

  Thanks worked fine !