SELECT sp. NAME |
FROM sys.all_objects AS sp |
WHERE ( |
( |
sp.type = N 'P' |
OR sp.type = N 'RF' |
OR sp.type = N 'PC' |
) |
AND ( |
CAST ( CASE |
WHEN sp.is_ms_shipped = 1 |
THEN 1 |
WHEN ( |
SELECT major_id |
FROM sys.extended_properties |
WHERE major_id = sp.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 |
) |
) |