Post reply

Encrypted Stored Procedures

  • January 4, 2010 at 7:25 am

    #228871

    Hi Friends,

    Can you please get the query to list all the Encrypted Stored Procedures in an database

    Thanks In Advance

  • January 4, 2010 at 8:49 am

    #1098477

    Query sys.procedures and use the OBJECTPROPERTY function with the 'IsEncrypted' property.

    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

  • January 6, 2010 at 9:03 pm

    #1100002

    Thanks gail for ypur help

  • May 3, 2013 at 4:41 am

    #1612137

    select b.name from sys.syscomments a join sys.objects b

    on a.id=b.object_id and a.text <> '' and b.type_desc in ( 'SQL_STORED_PROCEDURE','SQL_SCALAR_FUNCTION')

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

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