jayoub1 (4/8/2013)

---

Thanks, but I may need an example to learn how to do this.

This is a typical query that I would have to run on each database in the instance

use [msdb]

select user_name(o.schema_id) as [shema], o.name as [object],

o.type_desc as [type],

o.create_date as [create date]

from sys.all_objects o, sys.sql_modules s

where o.object_id = s.object_id

and s.definition is not null

and o.is_ms_shipped = 0

order by user_name(o.schema_id), o.name

How would I use the sp_msforeachdb to execute this. Also how will the resultes come out when you have several databases.

Your help is appriciated