Post reply

Encrryption on views, how to search ?

  • 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

  • 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'

  • July 7, 2005 at 3:15 pm

    #572098

    Thanks worked fine !

Viewing 3 posts - 1 through 3 (of 3 total)

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