Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

What does it mean when a file is modified?

19 October,2022 by Tom Collins

Question: What does it mean on a SQL Script when the file was last modified?  Here is an example of  of a file Properties and I'm interested in the modified date .


File_modifiedA file’s last modified date represents the  date\time that a file was  last written to. Normally , a file is modified or written to when a user opens and then saves a file, no data needs to be changed or added to

If your requirement is to track the actual date \ time when the file was executed than you'll need to execute the script through some sort of controlled mechanism , such as a scheduler and maintain the a log of run times. 

The same applies to tracking actual changes on the file - which should be maintained through some of  source control mechanism


Read more on files

Powershell script to compare two file sizes

Read a script file into Powershell CommandText with get-content

List files in Creation Time order with Powershell

Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on What does it mean when a file is modified? | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer