SQLServerCentral / SQL Server 2005 / Development / Encrypted Stored Procedures / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 03:18:46 GMT20RE: Encrypted Stored Procedureshttp://www.sqlservercentral.com/Forums/Topic841458-145-1.aspxselect b.name from sys.syscomments a join sys.objects bon a.id=b.object_id and a.text <> '' and b.type_desc in ( 'SQL_STORED_PROCEDURE','SQL_SCALAR_FUNCTION')Fri, 03 May 2013 04:41:46 GMTsuneet.mlvyRE: Encrypted Stored Procedureshttp://www.sqlservercentral.com/Forums/Topic841458-145-1.aspxThanks gail for ypur helpWed, 06 Jan 2010 21:03:54 GMTningaraju.nRE: Encrypted Stored Procedureshttp://www.sqlservercentral.com/Forums/Topic841458-145-1.aspxQuery sys.procedures and use the OBJECTPROPERTY function with the 'IsEncrypted' property.Mon, 04 Jan 2010 08:49:37 GMTGilaMonsterEncrypted Stored Procedureshttp://www.sqlservercentral.com/Forums/Topic841458-145-1.aspxHi Friends,Can you please get the query to list all the Encrypted Stored Procedures in an databaseThanks In AdvanceMon, 04 Jan 2010 07:25:11 GMTningaraju.n