Hi everybody
I need query that will determine which tables are created on primary file group or secondary file group...
I know that i can exectute sp_help 'tablename' to see on which file group the only one table is.
But i have 2000 tables and it is very slow to execute sp_help for every table.
alex

There's probably a nicer way to do it, but this seems to work:

SELECT DISTINCT sysobjects.name, sysfilegroups.groupname
FROM sysobjects
INNER JOIN sysindexes ON sysobjects.id = sysindexes.id
INNER JOIN sysfilegroups ON sysindexes.groupid = sysfilegroups.groupid
WHERE (sysobjects.xtype = 'U')

thanks
alex