Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    10

    Unanswered: How do I find out what tables belong to a filegroup?

    Is there anyway to find out what tables are in a particular filegroup in SQL2000 apart from running sp_help {tblnm}?

  2. #2
    Join Date
    May 2002
    Posts
    299
    You could use undocumented stored procedure...

    declare @id int
    set @i = object_id('mytb')
    exec sp_objectfilegroup @i
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •