SQL Server Performance Forum – Threads Archive
list object with filegroup
Hello, I want list all object that are owned by a specific filegroup. Someone knows how can I do that?. I mean, I want to see the ‘content’ of the filegroup. For example: table1 filegroup1table3 filegroup3
index3 filegruop1
etc..
actually, file group is by index, not table object
so the table could be in 1 fg, and each index in same or others anyways, join to sysindexes and use the groupid column
]]>