Cry How to...
List all filegroups
To get a list of all the filegroups, use:
select groupname from sysfilegroups
These notes have been tested against SQL Server 7.
About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.