Hi, i'm trying this :

DECLARE @query nvarchar(max)

select @query = S.DEFINITION

from sys.all_sql_modules s

inner join dbo.sysobjects s2 on s2.id = s.object_id

where s2.name='PROC_V3N_VENTIL_ACTION'

exec sp_executesql @query

It's truncating the @query so i get a synthax error. Please Help !