Solved

filegroups: tables in a filegroup

Posted on 2011-02-26
2
623 Views
Last Modified: 2012-05-11
Hei!

i have a DB from a vendour, which has many filegroups and aout 260 tables

Question: how do i find which tables belong to which filegroups?

//shan
0
Comment
Question by:shanj
2 Comments
 
LVL 40

Expert Comment

by:Sharath
ID: 34988496
check this: http://www.mssqltips.com/tip.asp?tip=1112
SELECT o.[name], o.[type], i.[name], i.[index_id], f.[name],i.data_space_id
FROM sys.indexes i
INNER JOIN sys.filegroups f
ON i.data_space_id = f.data_space_id
INNER JOIN sys.all_objects o
ON i.[object_id] = o.[object_id]
--WHERE i.data_space_id = 2 --* New FileGroup*

Open in new window

0
 
LVL 9

Accepted Solution

by:
mayank_joshi earned 250 total points
ID: 34990638
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question