Does someone know how to do it?

Thanks.

Il 15/02/2011 10.46, omtechguy ha scritto:
This is one of queries I've traced to get t-sql code

SELECT
NULL AS [Text],
ISNULL(smsp.definition, ssmsp.definition) AS [Definition]
FROM
sys.all_objects AS sp
LEFT OUTER JOIN sys.sql_modules AS smsp ON smsp.object_id = sp.object_id
LEFT OUTER JOIN sys.system_sql_modules AS ssmsp ON ssmsp.object_id =
sp.object_id
WHERE
(sp.type = N'P' OR sp.type = N'RF' OR
sp.type='PC')and(sp.name=N'nameofstoredprocedure' and
SCHEMA_NAME(sp.schema_id)=N'nameofschema')

Try replacing 'nameofstoredprocedure' and 'nameofschema' with your
object name and schema. This on SQL Server 2k5.

bye

Try this:

sp_helptext my_stored_procedure

--
Gert-Jan


omtechguy wrote: