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)

ScriptToFindWhichTablesBelongToWhichFileGroups

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: 130 | Views in the last 30 days: 1
 
Related Articles
FORUM

to which DB these tables belong

to which DB these tables belong

FORUM

A user belongs to multiple groups

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

FORUM

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

FORUM

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...

Tags
 
Contribute