Re: Located databases no longer used.
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/07/05
- Next message: Rocky: "Looking for Database Hammer -> SQL2000"
- Previous message: E Sullivan: "Best Practices Analyzer"
- In reply to: Pauly C: "Located databases no longer used."
- Next in thread: Pauly C: "Re: Located databases no longer used."
- Reply: Pauly C: "Re: Located databases no longer used."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 7 Feb 2005 15:32:43 -0500
No there is not. Your best bet is to run a continuous trace filtered on the
particular db(s) and see if anything accesses them.
-- Andrew J. Kelly SQL MVP "Pauly C" <paulysc@optonline.net> wrote in message news:04BD4AED-F586-4686-ADBB-0AD86A4EEF90@microsoft.com... > I'm looking to locate databases that have not been written to or accessed > for > a specified period of time; we are looking to locate databases that are > not > used anymore and clean house. Is there a system table or stored procedure > to > access this information? Thank you in advance for you assistance. > > Pauly C >
- Next message: Rocky: "Looking for Database Hammer -> SQL2000"
- Previous message: E Sullivan: "Best Practices Analyzer"
- In reply to: Pauly C: "Located databases no longer used."
- Next in thread: Pauly C: "Re: Located databases no longer used."
- Reply: Pauly C: "Re: Located databases no longer used."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
