Elenco tabelle presenti nei Filegroups
SELECT CONVERT(VARCHAR(30), OBJECT_NAME(s.id)) Tabella, fg.groupnameFROM sysindexes s INNER JOIN sysfilegroups fgON s.groupid = fg.groupidWHERE s.id > 100AND s.indid < 2 ORDER BY fg.groupname
utilissimo !!!!
Leggi tutto il post...