Web Listing 1: Retrieval Code for SQL Server 2005

DECLARE @ContentOfEncryptedObject 
   NVARCHAR(4000)
DECLARE @ObjectCodeLength INT

SELECT @ContentOfEncryptedObject = imageval,
       @ObjectCodeLength = 
          DATALENGTH(imageval)/2
FROM sys.sysobjvalues
WHERE objid = object_id('dbo.uspMyEncProc')
       AND valclass = 1 and subobjid = 1