登入
Microsoft.com
 
Microsoft
 
 
 

none
In Windows Explorer, the date modified of a database of SQL Server can't be updated after editing its record RRS feed

 > 

  • 問題

  • Question
    登入以投票
    0
    登入以投票

    Hi,

    In Windows Explorer, the date modified of a database file of SQL Server can't be updated after editing its record. The file is located in a file server installed Windows Server 2003 server  and SQL Server 2000 for multi-user.  If you have any suggestion about this question, please give me response.

    Finally, thanks you for studying my question.

    Tony

     

     

    2011年11月30日 下午 02:13
    |

解答

  • Question
    登入以投票
    0
    登入以投票
    Is it sql server db or Access db? Timestamp of sql db files will not change when someone make data change in the db. Will change when sql restarts or db file changes size (file grows or shrinks).
    2011年12月1日 上午 01:41
    |

所有回覆

  • Question
    登入以投票
    0
    登入以投票
    Why you want to modify that? Sql server controls those db files.
    2011年11月30日 下午 02:32
    |
  • Question
    登入以投票
    0
    登入以投票

    Rmiao,

    First, thank you for response. To let you clearly understand my question, I think I should explain it in detail here.

    Normally, after an end user edited a record in this database file (eg. Account.mdf) through my application developed with VB.NET, the date modified of this file shown in Windows Explorer should be correctly updated as the current date and time by MS SQL Server. However, my client found that it had not been updated so that he asked me why. I don't know the answer so I post the question here.

    Thank you for studying my question.

    Tony

     

    2011年11月30日 下午 03:55
    |
  • Question
    登入以投票
    0
    登入以投票
    Is it sql server db or Access db? Timestamp of sql db files will not change when someone make data change in the db. Will change when sql restarts or db file changes size (file grows or shrinks).
    2011年12月1日 上午 01:41
    |
  • Question
    登入以投票
    0
    登入以投票

    Rmiao,

    Thanks you for your explanation and answer. For my client, I want to learn more about it. Where can I find more information ?

    Tony

    2011年12月1日 上午 03:59
    |
  • Question
    登入以投票
    0
    登入以投票
    Sql installation comes with books online, you can find details of sql server in it.
    2011年12月1日 下午 03:18
    |