Haslett, Andrew
andrew.haslett at ilc.gov.au
Wed Feb 22 00:58:11 CST 2006
In EM: Management -> Security -> Process Info (sort by database) OR Take the database offline (All tasks -> take off-line) and see if the application falls over. A -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Lavsa, Rich Sent: Tuesday, 21 February 2006 5:38 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Determine if a database is no longer in use? Hello all, We have SQL Server 2000 sp3a running just to please some small off the shelf solutions we purchased, and to develop some small in house applications. WE also let this SQL install open to all Administrators as they should use this to log data if their application allows it to be logged to a SQL Server database, such as Insight Manager. Which is where my problem begins. For instance there are 2 databases set up on the server for Insight Manager. I know who installed them, however they do not remember if they pointed the latest install to the SQL server. So without confusing him and making him figure out what he had done, or if the installations on the server are valid or not I'd rather answer my own questions. What I want to do is delete them if they are not being used for anything. Then once I clean this up, I want to lock the SQL server down so that only I can create databases there, and if they need one built they need to ask me first as I am responsible for this server. Is there an easy way to determine if a database is no longer in use? Rich _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ *** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.