Is there a way to determine what filegroup a table belongs to by looking at
the
entry in the SysObjects or another system table? I found it easily enough f
or
indexes, but can't seem to find it for Table entries.
TIA,
-Steve-Never mind. I found it. I had to dig a little deeper into the system SP's.
Select s.groupname
From sysfilegroups s, sysindexes i
Where i.id = @.TableObjectID
And i.indid < 2
And i.groupid = s.groupid
-Steve-
"Steve Zimmelman" <skz@.charter.nospam.net> wrote in message
news:eglD3J5UGHA.5248@.TK2MSFTNGP10.phx.gbl...
> Is there a way to determine what filegroup a table belongs to by looking a
t
> the entry in the SysObjects or another system table? I found it easily en
ough
> for indexes, but can't seem to find it for Table entries.
> TIA,
> -Steve-
>
No comments:
Post a Comment