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
Jeff