July 10, 2003 at 8:52 am
Anyone know how to tell what tables/indexes etc. are on each file group? I want to know what objects have been created on each file group (we have 3).
37SOLUTIONS
We'll find the one for you!
Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting
July 10, 2003 at 9:23 am
Try this.
select object_name(sysind.id) as TableNme, sysind.name as ObjName, sysfg.groupname as GroupName
from sysindexes sysind
inner join sysfilegroups sysfg
on sysind.groupid = sysfg.groupid
inner join sysobjects sysobj
on sysind.id = sysobj.id
where sysobj.xtype <> 'S'
and sysind.name not like '_WA%'
order by sysind.TableNme
July 10, 2003 at 9:41 am
Perfect, thanks!!!
37SOLUTIONS
We'll find the one for you!
Website Hosting | Website Design | MSSQL/MySQL Hosting | Database Development | Research/Consulting
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply