Hi

An example for the names would be grate 😉

Well, assumed the file group name would be "FILE_GROUP_YYYY_M" where "YYYY" identifies the year and "M" identifies the month.

DECLARE @date datetime

SET @date = GETDATE()

DECLARE @fg_name NVARCHAR(128)

SET @fg_name = 'FILE_GROUP_' + CONVERT(VARCHAR(4), DATEPART(YEAR, @date)) + '_' + CONVERT(VARCHAR(2), DATEPART(MONTH, @date))

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 = @fg_name

Greets

Flo