Viewing filegroups

Question

Viewing filegroups

Alex Huth

SSC Enthusiast

Points: 111
More actions
August 6, 2005 at 4:38 am

#89334

Hi experts!
How is the statement for viewing filegroups in a db? Searched for it in the OLB, but didn´t found it.
btw: as i am a absolute beginner, i asked me if there is a forum for Newbies. I will not annoy anyone with really basic questions. If not i will post all my questions in the specalized forum, if i can´t find discussed in the past.
thanks in advance
Alex

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

EXEC sp_helpfilegroup

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Alex Huth SSC Enthusiast Points: 111 More actions · Answer 2

Ok. Already found:

select * from sysfilegroups

next questions:

viewing files in the filegroups?

Alex Huth SSC Enthusiast Points: 111 More actions · Answer 3

Thanks, that helps for new additional filegroups. For example if i made a filegroup called testgroup, i am able to show it like this:

EXEC sp_helpfilegroup testgroup

But how can i show the file in the primary group?

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 4

I do not have a server to test with, but I suppose sp_helpfilegroup 'PRIMARY' might work. If you execute it with no parameters it shows all filegroups.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Alex Huth SSC Enthusiast Points: 111 More actions · Answer 5

Oh,that´s it. I´ve forgotten that it is a keyword. Have tried it as normal query.

Thanks