• Can you run this on both servers

    SELECTOBJECT_NAME(s.object_id) AS TableName,

    s.name AS StatsName,

    s.auto_created,

    s.user_created,

    STATS_DATE(s.object_id, s.stats_id) AS StatsDate,

    c.name AS ColumnName

    FROMsys.stats s

    INNER JOINsys.stats_columns sc

    ON s.object_id = sc.object_id

    INNER JOINsys.columns c

    ON s.object_id = c.object_id

    AND sc.column_id = c.column_id

    ORDER BYs.object_id,

    s.name,

    c.column_id

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]