Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    9

    Unanswered: is there any way ( table ) to find out when last time statistics got updated for a ta

    Hello All,
    is there any way ( table ) to find out when last time statistics got updated for a table ??? ( using script)


    thank you
    jagdish

  2. #2
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Use this

    USE [YOUR DATABASE]
    SELECT 'Index Name' = i.name,
    'Statistics Date' = STATS_DATE(i.id, i.indid)
    FROM sysobjects o, sysindexes i
    WHERE o.name = 'employee' AND o.id = i.id
    GO


    or
    STATS_DATE ( table_id , index_id )

    table_id

    Is the ID of the table used.

    index_id

    Is the ID of the index used.


    Last edited by sqlserver2k; 06-06-02 at 11:54.

  3. #3
    Join Date
    Jun 2002
    Posts
    9
    Thank you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •