Needs Help on Indexes?

• Bagath

  SSCrazy

  Points: 2409

  More actions

  September 18, 2008 at 12:40 am

  #193802

  Good Day All,

  I need a help regarding SQL Server 2000 index informatin of tables.

  Recently some tables indexes were re-builted now what i want to know is,can i get which indexes got updated? Is there any way or script to get the updated date like wise?

  This would be very helpful to me..

  Thanks in advance,

• RP_DBA

  SSCertifiable

  Points: 5116

  More actions

  September 18, 2008 at 7:03 am

  #873584

  Try this:

  selectso.[name] as tbl_name

  , si.[name] as indx_name

  , STATS_DATE(si.[id], si.indid) as StatisticsDate

  fromdbo.sysobjects so

  inner join dbo.sysindexes si on so.[id] = si.[id]

  whereINDEXPROPERTY(si.[id], si.[name], 'IsStatistics') = 0 -- remove statistics

  _____________________________________________________________________
  - Nate

  @nate_hughes