Re: Index Creation Date
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/27/02
- Next message: Sue Hoegemeier: "Re: SQL2k Sqlagentproxy fails to logon"
- Previous message: Anith Sen: "Re: Index Creation Date"
- In reply to: Puneet Parashar: "Index Creation Date"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Thu, 27 Jun 2002 12:57:34 -0600
I don't think SQL Server keeps that information anywhere.
You can check last updated date with show_statistics but
nothing I can think of with creation dates.
If they were required to script all of the ddl statements,
you would have some type of record if you used version
control methods or software. It would also help in moving
changes from development to production.
-Sue
On Thu, 27 Jun 2002 11:21:17 -0700, Puneet Parashar
<parashar22@hotmail.com> wrote:
>Hi,
>
>My developers are creating many indexes by themseleves, and i want to
>know when was the index created. i looked into sysindexes table but that
>does not have any information about the creation date of the index. If
>any one can help me to determine the date on which indexes were
>created/recreated that would be a great help.
>
>Thanks,
>Puneet
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!
- Next message: Sue Hoegemeier: "Re: SQL2k Sqlagentproxy fails to logon"
- Previous message: Anith Sen: "Re: Index Creation Date"
- In reply to: Puneet Parashar: "Index Creation Date"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
