Home Dashboard Directory Help
Search

Rebuild index, sys.objects, modify_date by Andrea_Benedetti


Status: 

Closed
 as Fixed Help for as Fixed


2
0
Sign in
to vote
Type: Bug
ID: 767101
Opened: 10/11/2012 1:40:22 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Operations such as rebuilding index change the "modify_date" in sys.objects for the table
Details
Sign in to post a comment.
Posted by Microsoft on 2/20/2013 at 11:50 AM

Hi Andrea. Thanks for your feedback. This looks like our online documentation needs to be updated. In both non-clustered and clustered index cases will result in recompile which causes modify_date to be updated. So the behavior is by design but the documentation needs to reflect that.
Posted by andreal on 10/15/2012 at 3:28 AM
I've noticed the repro steps rebuild a non-clustered index, so how the index rebuild affects the modify_date still require an explanation. MSDN states: "modify_date also changes when a clustered index on the table or view is created or altered"
Posted by andreal on 10/15/2012 at 3:16 AM
From MSDN: http://msdn.microsoft.com/en-us/library/ms190324(v=sql.110).aspx
modify_date:
"Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when a clustered index on the table or view is created or altered."
Sign in to post a workaround.