Home Forums SQL Server 2005 Administering Script to show the statistics from all user tables from a DB RE: Script to show the statistics from all user tables from a DB

  • nice effort!

    just as a more streamlined form, you don't need a cursor to generate the same results:

    you can do it as a single set based operation instead:

    SELECT

    object_schema_name(OBJECT_ID) as SchemaName,

    object_name(OBJECT_ID) as Objeto,

    STATS_DATE(OBJECT_ID,STATS_ID)

    StatDate,*

    FROM SYS.STATS

    WHERE OBJECT_ID IN(SELECT object_id from sys.tables)

    order by

    object_schema_name(OBJECT_ID),

    object_name(OBJECT_ID),

    stats_id

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!