Viewing post 1 (of 2 total)
I found one way to get the information:
select a.name, b.name,a.groupid
from sysindexes a,
sysfiles b
where a.groupid = b.groupid
order by b.name,a.name
Maybe there is a better way,... but couldn't find sp_helpFileGroupObjects
May 18, 2004 at 10:17 am
#506815