Post reply

put DBCC data in table

  • 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.

  • 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]

  • 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.

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

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