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 |
|
CanadaDBA
583 Posts |
 Posted - 2008-02-20 : 15:28:42
|
| How can I find out when a database was last time opened/accessed/updated?Canada DBA |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-20 : 15:37:16
|
| Create a DDL trigger in 2005 to find the results. |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2008-02-20 : 15:54:00
|
| Actually the problem is that on a server I have both SQL Server 2000 and 2005. There are some databases on both servers but I don't know which one is being used and which one is not. If the DBs on 2005 are in use, and none of DBs in 2000 are not used, then I can stop SQL 2000 and even uninstall it.Canada DBA |
|
|
|
rajeshk
Starting Member
15 Posts |
Posted - 2008-02-21 : 05:14:55
|
| Check the SQL server log |
|
|
|
CanadaDBA
583 Posts |
Posted - 2008-02-21 : 08:52:00
|
| What should I expect in the SQL log? Both SQL Servers are running and the log doesn't show about databases usage. Please explain more.Canada DBA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 15:16:32
|
| Sql2k5 comes with schema change history report, but you need some sql auditing tool for sql2k. |
|
|
|
|
|
|
Access to a DB