Find out what file group objects are stored on

• David Kranes

  SSCrazy

  Points: 2523

  More actions

  February 15, 2007 at 12:35 pm

  #172257

  Hello, does anyone have a query that will report tables and indexes along with what filegroup they are created on?

  

  Thank you,

  David

  Best Regards,

  ~David

• Dinakar Nethi-176633

  SSCarpal Tunnel

  Points: 4689

  More actions

  February 15, 2007 at 5:27 pm

  #690110

  You could script out the tables along with the indexes from Mgmt Studio.

  ******************
  Dinakar Nethi
  Life is short. Enjoy it.
  ******************