just a thought
;with SD as (
SELECTname,
database_id,
create_date
FROM sys.databases
where name not in ('master','tempdb', 'model', 'msdb')
)
SELECTSD.name,
SD.create_date,
IUS.database_id,
IUS.index_id,
IUS.user_seeks,
IUS.user_scans,
IUS.user_lookups,
IUS.user_updates,
IUS.last_user_seek
FROM SD
LEFT OUTER JOIN sys.dm_db_index_usage_stats AS IUS
ON SD.database_id= IUS.database_id
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day