June 21, 2004 at 2:16 pm
We are doing some cleanup and we have databases that we believe have not been accessed for quite sometime. Does anyone know how to find out when a database was last accessed?
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 22, 2004 at 2:56 am
Unless the db is audited, you can't find out.
SQL Server itself doesn't keep track of this.
/Kenneth
June 22, 2004 at 6:18 am
Thanks - I was fairly certain that was the case but I had hoped there was an undocumented "feature" somewhere.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply