Post reply

Filegroups in SQL Server 2000

  • April 20, 2007 at 2:59 am

    #116925

    Hi All,

     

    I've got about 8 filegroups on one of my databases. I would like to know how to list filegroup name,filename in T-SQL.

     

    Please help..

  • April 20, 2007 at 3:21 am

    #701654

    This gives you the name of the filegroup, the logical filename and the path.

    SELECT fg.Groupname, f.Name, f.filename

    FROM sysfiles f JOIN

    Sysfilegroups fg

    ON f.groupid = fg.groupid

    In SQL 2005 you would use the Managemebnt views.

    markus

    [font="Verdana"]Markus Bohse[/font]

  • April 20, 2007 at 3:42 am

    #701661

    Thanks a lot Markus. That really helped a lot.

    Regards

    Songezo

Viewing 3 posts - 1 through 2 (of 2 total)

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