SELECT udf. NAME |
FROM sys.all_objects AS udf |
WHERE ( |
udf.type IN ( |
'TF' , |
'FN' , |
'IF' , |
'FS' , |
'FT' |
) |
) |
AND CAST ( CASE |
WHEN udf.is_ms_shipped = 1 |
THEN 1 |
WHEN ( |
SELECT major_id |
FROM sys.extended_properties |
WHERE major_id = udf.object_id |
AND minor_id = 0 |
AND class = 1 |
AND NAME = N 'microsoft_database_tools_support' |
) IS NOT NULL |
THEN 1 |
ELSE 0 |
END AS BIT ) = 0 |