Hi

Do you mean something like this?

SELECT st.name table_name,

si.name index_name,

sd.name data_space_name,

'DBCC DBREINDEX("' + SCHEMA_NAME(st.schema_id) + '.' + st.name + '", ' + QUOTENAME(si.name) + ')'

FROM sys.indexes si

JOIN sys.tables st ON si.object_id = st.object_id

JOIN sys.data_spaces sd ON si.data_space_id = sd.data_space_id

WHERE sd.name = 'ATTACHMENTS'

37 file groups per month? I always thought file groups are master data... :-D.

Greets

Flo