July 16, 2003 at 1:02 pm
Is there a way we could get the list of tables residing on a filegroup and the size/space occupied by each table? Thanks
July 16, 2003 at 1:18 pm
To get the list of the objects on a Particular file group use the following
SELECT DISTINCT un.name, ung.groupname
FROM sysobjects un INNER JOIN sysindexes si ON un.id=si.id
INNER JOIN sysfilegroups ung ON si.groupid=ung.groupid
WHERE ung.groupname= ‘FG_Name’
I believe there is a stored proc some where on this site to get the table size, Search for the table size
Shas3
July 17, 2003 at 9:57 am
try: sp_spaceused '<table name>'
I usually set this SP into a loop of each table I want info on and save the results to a temp table to be displayed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply