Post reply

Determining what tables in Filegroups

  • November 11, 2005 at 1:42 pm

    #102923

    Can someone tell me how to find out what tables are located in filegroups?  I have a 400+gb database with a primary filegroup and 9 secondary filegroups. I inherited this db when the dba who built it left suddenly without leaving any documentation. The business owners requested I find this information for them.

    There must be a way to examine the filegroups and determine what tables are located within them.

    HELP!!

  • November 11, 2005 at 2:02 pm

    #603509

    I have used this script in the past.

    http://www.umachandar.com/technical/SQL70Scripts/Main32.htm



    Michelle

  • November 11, 2005 at 3:31 pm

    #603529

    Thanks very much, the results of the script were just what I was looking for.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply