Encrypted Stored Procedures

• ningaraju.n

  SSCrazy

  Points: 2322

  More actions

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• ningaraju.n

  SSCrazy

  Points: 2322

  More actions

  January 6, 2010 at 9:03 pm

  #1100002

  Thanks gail for ypur help

• suneet.mlvy

  SSC Eights!

  Points: 964

  More actions

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