Where to find out detail of when the Index is created and modified?

Question

Post reply

Where to find out detail of when the Index is created and modified?

sivaprasad

SSCertifiable

Points: 6183
More actions
April 28, 2005 at 3:00 am

#88890

Where to find out detail of when the Index is created and modified?
I need to find out when the index are created and modified. I do no have any clue on where to look for.
- S Siva Prasad
Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 1

The sql resouce kit comes with a system table map which will help you.

The other question is why? surely you would have control over object creation on a server ?

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Jimmy Jen SSCrazy Points: 2915 More actions · Answer 2

You can use system function STATS_DATE(table_id, index_id) to return the date when index was last updated.

sivaprasad SSCertifiable Points: 6183 More actions · Answer 3

Colin

It is better you avoid generic reply, if you can't give direct answer.

Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 4

Colin is attempting to provide help.

Questions are not always clear as to their intent, giving more information rather than less helps other to help you. Colin is just trying to get that information to be of greater assistance. Berating him for that is pointless and ridiculous.

Shamless self promotion - read my blog http://sirsql.net

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

Tststs, such answers are inappropriate here

One might be inclined to presume you do some basic research on your own, before asking a question. This is a FAQ! A simple search here would have returned many useful threads.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 6

How to ask questions the smart way

You said yourself that you did not have a clue where to look. Colin is giving you a clue to work from.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

mark baekdal-145375 SSCrazy Points: 2200 More actions · Answer 7

If you had a database change management pratice in place these questions would always be answered. Ever thought about getting one?

regards,

Mark Baekdal

http://www.dbghost.com

http://www.innovartis.co.uk

+44 (0)208 241 1762

Build, Comparison and Synchronization from Source Control = Database change management for SQL Server

Rafeeque M.K. Ten Centuries Points: 1205 More actions · Answer 8

Mr. Prasad,

It is better to keep patiance and hear others if you are rising a question for help whether answer is generic or not.Second if question is of generic nature don't expect a full fetured answer.A simple search on the net will give enough clue to your question? is in't it?????????.

sivaprasad SSCertifiable Points: 6183 More actions · Answer 9

I apologise for my comments...

But still I am waiting for answers to query rather than to my comments.

If you require more input please let me know.

Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 10

What exactly are you looking for? You can use the function that Jimmy Jen mentioned, STATS_DATE, to get the time when the statistics for the index was last updated. If by modified you mean when something was changed in the data that is indexed, then there is no automatic way of checking that. I do not think the date when an index is created is stored anywhere.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/