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

*** Sent via Developersdex http://www.developersdex.com ***

Try this:

SELECT OBJECT_NAME(I.id) AS tablename, G.groupname
FROM sysfilegroups AS G
JOIN sysindexes AS I
ON I.groupid = G.groupid
AND I.indid <= 1

--
David Portas
SQL Server MVP
--