Prev: How to delete .txt files from \Program+Files\Microsoft+SQL+Server\MSSQL.1\MSSQL\LOG
Next: @@VERSION Gives Different Info Than Enterprise Manager (SQL 2000)
From: BLilly on 12 Aug 2010 15:01
Is there any way to tell when the last time data in a file or filegroup has
changed?
From: Amol Lembhe on 13 Aug 2010 02:59

Look for date modified in windows explorer that will give you idea of last
time when this file was accessed.
also you can look at default SQL trace to determine when respetice database
accessed last time
"BLilly" wrote:

> Is there any way to tell when the last time data in a file or filegroup has
> changed?
 | 
Pages: 1
Prev: How to delete .txt files from \Program+Files\Microsoft+SQL+Server\MSSQL.1\MSSQL\LOG
Next: @@VERSION Gives Different Info Than Enterprise Manager (SQL 2000)