SELECT object_type = OBJ.type_desc,

[schema_name] = SCHEMA_NAME(OBJ.[schema_id]),

[object_name] = OBJ.name,

SM.[definition]

FROM sys.objects OBJ

JOIN sys.sql_modules SM

ON SM.[object_id] = OBJ.[object_id]

WHERE OBJ.type_desc IN

(

N'SQL_STORED_PROCEDURE',

N'SQL_SCALAR_FUNCTION',

N'SQL_INLINE_TABLE_VALUED_FUNCTION',

N'SQL_TABLE_VALUED_FUNCTION',

N'SQL_TRIGGER',

N'VIEW'

)

AND SM.uses_ansi_nulls = 0

AND OBJ.is_ms_shipped = 0

ORDER BY

object_type,

[schema_name],

[object_name];