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];

ANSI_NULLS ON