sql server msde: Dumb question. I have Greatplains 7.5 on MSDE running. I notice that the
data files in SQL data folder on the server do not change often.
Transactions are done daily but the date stamp on the files do not reflect
if. I can see allof the transactions in Greatplains fine. What is the
deal? Thanks

Hi

The timestamp on *.MDB, *.LDF and *.NDF files are only updated on SQL
Server/MSDE startup and shutdown.

The database engine keeps the files locked exclusively, so the timestamp is
only updated by the OS when the file is acquired and released.

This is by design, and all OS's behave in the same way with exclusively
locked files.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]