Solved

filegroups: tables in a filegroup

Posted on 2011-02-26
2
609 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
Comment Utility
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
Comment Utility
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now