File Group

Last Post 17 Apr 2002 06:48 AM by satya. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Shawn_SQL
New Member
New Member

--
17 Apr 2002 05:49 AM
I have a Windows NT 4.0 server with SP6a. It has SQL Server 7.0 with SP3.

There is a database that was created by third party software. It has many different file groups that have been used in the database.

Does anyone know a query that would tell me what tables are in what file groups
satya
New Member
New Member

--
17 Apr 2002 06:48 AM
SP_HELPDB gives the basic information about file and filegroups used for that database.
Shawn_SQL
New Member
New Member

--
17 Apr 2002 07:33 AM
That stored procedure provides a lot of information about the different files and there sizes, but how do I find what tables are located in each file and file group?
You are not authorized to post a reply.

Acceptable Use Policy