SQL EXPLORER
About Me
Mohamed Faizal
Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G
View my complete profile
Monday, August 4, 2014
Get index creation Date
Select
Name
as
IndexName
,
STATS_DATE
(
object_id
,
index_id
)
as
IndexCreatedDate
From
sys
.
indexes
where
object_id
=
object_id
(
'dbo.datagathering'
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment