April 7, 2003 at 9:00 am
How can I know when was the last time a database has been accessed? I want to see if a database is still active. Are there a way to view database log file? I got a share violation when I try to open the log file.
April 7, 2003 at 9:06 am
Hi,
I think, you can find by using third party tool, like Lumigent log explorer.
Madhu.
madhusudannaidugundapaneni
Madhu
April 7, 2003 at 10:24 am
With sp_who2 you can view if any user is accesing the db in that moment. When you said 'I got a share violation when I try to open the log file.' you meant that you where trying to restore the db?
April 7, 2003 at 11:57 am
"sharing violation" occured when I tried to view the log file in a text editor.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply