Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Index creation and Updated date in 2008 Expand / Collapse
Author
Message
Posted Thursday, July 29, 2010 2:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:41 PM
Points: 207, Visits: 475
Hello everyone

How do i know when index was created and updated in SQL Serve 2008?
Post #960549
Posted Thursday, July 29, 2010 6:18 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 24, 2011 9:55 AM
Points: 524, Visits: 219
There is no direct way of finding the creation date of an index. But however if you look in sysobjects there is a creation date for Primary Key or Unique Constraints.Indexes associated with primary Primary Key or Unique Constraints creation date can be known.
check if there are any new DMVs (Dynamic Mgmt Views) in sql server 2008 which can help you in getting creationDate.

check this query
select
crdate,
i.name,
object_name(o.id)
from
sysindexes i
join sysobjects o ON o.id = i.id
order by
crdate desc

Thanks,
Amit Kulkarni
Post #960643
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse