Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-30 : 10:44:13
|
| Andy writes "Hi,How can I determine the last used date / last modified date, for any data and/or structural changes for any user database within SQL Server 2000?I was trying "dbname.dbo.sysobjects" using the field of "crdate"...Example:SELECT TOP 1 crdatefrom dbname.dbo.sysobjectsORDER BY crdate DESCThis would give me the "most recent date" of crdate for that table. But my assumptions may be incorrect.I am looking for something this would help me find out which databases, per server, that has not been in use for more than 90 days, so I can produce a list of databases that can be proposed to be dropped, that are no longer being used by the developers on the "developer SQL server". Any ideas?Thanks,Andy" |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-08-30 : 12:52:37
|
| I don't believe that SQL Server doesn't store anything like that, so your query won't give you the results you need.Ken |
 |
|
|
|
|
|
Determining the last used date for a database SQL 2000