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 |
|
racalvert
Starting Member
2 Posts |
 Posted - 2007-03-06 : 07:22:51
|
| Good morning all... first time poster here.Very new to SQL server, and the database world in general. We're an old Oracle shop, and our Oracle dba's are pretty set in their ways and aren't too excited about supporting SQL server. Understandable, change is tough sometimes. Being the new kid in town, I have made it my goal to wrangle our SQL 2000/2005 environment and carve out my own little niche.My first order of business is to do some general cleanup and documentation. So, my question is this... is there a way to determine when the last few user connection to a database were? I have a host of databases that I suspect are no longer in use, but no one can seem to identify them. Before I delete them, I definitely want to make sure they aren't being used by some off-the-beaten-path app that I am unaware of. I did a search here and a general Google search that was fruitless. I'm not the beast Googler though. :)Any advice here will be greatly appreciated!-Alan-edit: My idea of a solution would be a query to show, say, the last 10 connections to a particular database. Username, date, time, etc. would be spectacular. |
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2007-03-06 : 07:31:32
|
| How about moving them to another server or rename them and see what happens. Deletion is a bit final. |
 |
|
|
racalvert
Starting Member
2 Posts |
Posted - 2007-03-06 : 07:52:29
|
| Didn't really mean delete per se... poor choice of words. I have actually been detaching and archiving, which I will continue to do. My main question here is how to see (or log) the last few connections to a particular database. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-06 : 07:58:02
|
| Run the profiler against the desired database to see if any app is accessing it.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
|
|
Logging activity/connections