If we give SP_HELP , we'll know to which File Group the table belongs.
If we give SP_HELPFILEGROUP , we'll know the logical and physical file names along with other information that belong to the given File Group.
But have you ever tried that, given a file group, how to find all the tables that belong to that file group?
OR You want to know what are all the tables that belong to each file group. Here are two different ways of querying such possibilities.
2001-08-22
728 reads