Rebuild index, sys.objects, modify_date - by Andrea_Benedetti

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 767101 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/11/2012 1:40:22 PM
Access Restriction Public

Description

Operations such as rebuilding index change the "modify_date" in sys.objects for the table
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."