Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)


By Krishna Sonti,

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.

Total article views: 131 | Views in the last 30 days: 1
Related Articles

to which DB these tables belong

to which DB these tables belong


A user belongs to multiple groups

Hello, I'm a bit confused about permissions. If a user, User1, belong to multiple groups, say ...


Get a listing of table names on a particular file group

I need to get a listing of tables belonging to a particular file group


Couldn't find to which windows group login belongs to

Hello, There is a login which is windows authenticated and user is able to login using that login...