sql server clients: Something like this

SELECT
OBJECT_NAME(o.id),
fg.groupname
from
sysobjects o JOIN sysindexes si ON o.id = si.id
JOIN sysfilegroups fg ON si.groupid = fg.groupid
where
o.xtype = 'U'

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]

Hi All
Is there any why to know filegroup name object wise. Mean which object
is belong with which filegroup.


Thanx in Advance

Farhan Iqbal