How to list all filegroups for a specific database?

Hi, all here,

Would please any expert here give me any guidance for how to list all filegroups for a specific database within SQL Server 2005?

Thanks a lot in advance for that.

With best regards,

Yours sincerely,

Within the database use the following command:

SELECT * FROM sys.filegroups

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

use northwind
select * from sysfiles

select * from sysfilegroups

|||

Hi, Jens and Joeydj, thanks a lot for your guidance.

With best regards,

Yours sincerely,