Re: Located databases no longer used.
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/08/05
- Next message: Martin Schmeller: "Error 8115 in Enterprise Manager when I want to shrink an attched database"
- Previous message: Allan Mitchell: "Re: DTS Programming Question -- how to remove custom transformations"
- In reply to: Pauly C: "Re: Located databases no longer used."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Feb 2005 15:48:02 -0500
Didn't even realize that was you<g>. Unfortunately the answer is still
no<g>... Everyone wants that feature though.
-- Andrew J. Kelly SQL MVP "Pauly C" <paulysc@optonline.net> wrote in message news:A5BDC793-6A72-4F0B-9891-025DC99D927C@microsoft.com... > Bummer, Thanks Andy. Tony B say's hello. > > Pauly C > > "Andrew J. Kelly" wrote: > >> 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: Martin Schmeller: "Error 8115 in Enterprise Manager when I want to shrink an attched database"
- Previous message: Allan Mitchell: "Re: DTS Programming Question -- how to remove custom transformations"
- In reply to: Pauly C: "Re: Located databases no longer used."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
