Post reply

Data and Text on Filegroups

  • February 17, 2005 at 11:33 am

    #65656

    I know where to look to find which file group(s) a table's data and indexes are on.  However, I can't seem to find a query or command to show me the file group where the TEXT data of a table is. 

    Anyone know? 

  • February 17, 2005 at 1:55 pm

    #542937

    select filegroup_name(groupid) as filegroup ,object_name(id) as table_name from sysindexes where indid = 255

     

  • February 18, 2005 at 7:26 am

    #543070

    Thanks.  That's what I needed.

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

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