WHERE OBJECTPROPERTY(id , 'IsMsShipped') = 0

WHERE OBJECTPROPERTY(OBJECT_ID(tablenamecolumn) , 'IsMsShipped') = 0

WHERE OBJECTPROPERTY(OBJECT_ID(schemanamecolumn+'.'+tablenamecolumn) , 'IsMsShipped') = 0

SELECT name 
FROM sys.objects 
WHERE type = 'p' and name not like 'sp[_]%' AND is_ms_shipped=0
ORDER BY name

SELECT name 
FROM sysobjects 
WHERE type = 'p' and name not like 'sp[_]%' AND OBJECTPROPERTY(object_id,'isMSShipped')=0
ORDER BY name