filegroupe

Question

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

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

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 1

Hi..Pls try this

I have this query:

select sys.tables.name,sys.data_spaces.name

from sys.tables,sys.data_spaces

where sys.tables.lob_data_space_id = sys.data_spaces.data_space_id

order by sys.tables.name

a.e.ghorbani Right there with Babe Points: 741 More actions · Answer 2

thanks , but that show all of tables "primary" and it is not true.what am i doing???

Adiga One Orange Chip Points: 27284 More actions · Answer 3

You may find this script useful.

select

db_name()as DBName,

object_name(i.id) as TableName,

fg.groupname as FileGroup

from sysfilegroups fg, sysindexes i

and i.indid < 2

and i.groupid = fg.groupid

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga