Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lici
Starting Member
11 Posts |
 Posted - 2004-06-09 : 14:25:41
|
Hi!I like to know when a index was created and the login that created it.Tnx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-09 : 14:43:45
|
| Index information is stored in sysindexes. sysindexes does not have a crdate (Create date) column like sysobjects does.Tara |
 |
|
|
lici
Starting Member
11 Posts |
Posted - 2004-06-09 : 14:53:05
|
An index is an db object , is there any place where the Creation Date is stored?I think that must be a place on SQLServer where this information is stored.Any thoughts? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-09 : 14:54:29
|
| Creation date of an index is not stored.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-09 : 15:10:53
|
| I'm amazed...just went to sysobjects and found everything BUT Indexes listed there...what'd they do slap this damn rdbms together overnight?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-09 : 15:16:53
|
| Well I guess if the index is a PK, FK, or UNIQUE constraint, then you'd see the creation date in sysobjects. Otherwise, you're out of luck.The system table design came from Sybase days.Tara |
|
|
|
lici
Starting Member
11 Posts |
Posted - 2004-06-09 : 17:21:44
|
| An index is an db object , is there any place where the Creation Date is stored?I think that must be a place on SQLServer where this information is stored.Any thoughts? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-09 : 17:51:03
|
| We all know that an index is a database object. But information about the index is not stored in sysobjects like the other objects. Index information is stored in sysindexes which does not have a creation date column.So the answer is no, there is no way to know when the index was created or who created it.Tara |
|
|
|
lici
Starting Member
11 Posts |
Posted - 2004-06-09 : 18:07:23
|
| tnx Tara I appreciate your help and your interest |
|
|
|
|
|
|
Date creation from a index