Script to find out Stored procedures/functions that doesn't have extended properties defined

Question

Hello All,

I am trying to write a script to find out what all stored procedures/functions in a dev server that doesn't have extended properties defined. Please help me how to do it.

Thank You

Answer 1

Tables:

select t.* 
from sys.tables t 
left join sys.extended_properties p  on p.major_id = t.object_id  AND class = 1 
WHERE p.name IS NULL

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 2

Procs/functions

select so.name, t.* 
from syscomments t
join sysobjects so on t.id = so.id
left join sys.extended_properties p  on p.major_id = t.id  
WHERE p.name IS NULL

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 3

Thanks so much chuck. That worked