put DBCC data in table

• S_Kumar_S

  SSCrazy Eights

  Points: 9037

  More actions

  July 30, 2010 at 5:45 am

  #146483

  Hi All

  I want to put output of DBCC SHOW_STATISTICS (table_name, index_name) in table. But the problem is it returns three table And I want data of second resultset in table. Any way to do it??

  Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

• RichardDouglas

  SSCarpal Tunnel

  Points: 4029

  More actions

  July 30, 2010 at 6:43 am

  #1200260

  You can specify exactly which table to return, by default it will return all three options.

  To return the second table as you have specified run the following:

  DBCC SHOW_STATISTICS(Table, Index) WITH DENSITY_VECTOR

  Rich

  Hope this helps,
  Rich

  [p]
  [/p]

• S_Kumar_S

  SSCrazy Eights

  Points: 9037

  More actions

  July 30, 2010 at 7:05 am

  #1200282

  Thanks, this was a new learning for me...

  Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.