SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.v_ps_value')) AS [Definition]; 

create  VIEW [dbo].[v_ps_value]
AS
SELECT	property.id,
		property.descriptor_id,
		property.owner_id,
		property_value.value as value
FROM	dbo.property INNER JOIN	 dbo.property_value 

SELECT LEN(OBJECT_DEFINITION (OBJECT_ID(N'dbo.v_ps_value')) AS [Definition]);

---------
DECLARE @procdefn varchar(MAX); 
SET @procdefn =  'CREATE PROCEDURE dbo.prc_LongStringLength
AS
BEGIN
                                SELECT LEN(''' + REPLICATE ( CAST('<' AS varchar(MAX)), 65535) + ''');
END' ; 
EXEC ( @procdefn ); 
SELECT OBJECT_DEFINITION(OBJECT_ID('dbo.prc_LongStringLength')) AS [XML_F52E2B61-18A1-11d1-B105-00805F49916B];
------------
CREATE PROCEDURE dbo.prc_LongStringLength
AS
BEGIN
                                SELECT LEN('<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
<<<<<<<<<<<<<<<<

exec sp_helptext 'dbo.View'

DECLARE
   @objName nvarchar(256);
SET @objName = N'dbo.prc_LongStringLength';
/* Script out objects if they exist*/
IF  EXISTS (SELECT *
              FROM sys.objects
              WHERE object_id
                    =
                    OBJECT_ID(@objName)
                AND type IN (N'FN', N'IF', N'TF', N'FS', N'FT',N'P'))
    BEGIN
        DECLARE
           @t TABLE(line nvarchar(max))
    END;
INSERT INTO @t
EXEC sp_helptext @objName;
DECLARE
   @ddl nvarchar(max);
SELECT @ddl = '';
/* Change CREATE to ALTER because this object all ready exists */
SELECT @ddl = @ddl + REPLACE(line, 'CREATE procedure', 'ALTER PROCEDURE')
  FROM @t;
PRINT @ddl;
GO