Assumes no named instances. Unfortunately there seems to be no general answer for those.
On Mon, Jan 12, 2009 at 12:22 PM, Tigran K <tigr...@gmail.com> wrote: > try this > > use master > select * from sys.sysdatabases > > --Tigran > > > On Mon, Jan 12, 2009 at 4:51 AM, Doige, Clayton <clayton.do...@cme-net.com > > wrote: > >> Hi all, I don't do much with SQL so apologies if this is a daft >> question. >> >> >> >> Is there a nice easy way to generate a list of all databases on a server >> which includes the file paths for the log and data files? >> >> >> >> Thanks for any assistance >> >> >> >> *Clayton Doige* >> >> IT Project Manager >> >> *C**M**E** Development Corporation* >> >> T: 020 7430 5355 >> >> M: 07949 255062 >> >> E:clayton.do...@cme-net.com >> >> W:www.cetv-net.com >> >> ______________________________________________________________________ >> This electronic mail message and any attached files contain information >> intended for the exclusive use of the person(s) to whom it is addressed and >> may contain information that is proprietary, privileged, confidential and/or >> exempt from disclosure under applicable law. If you are not the intended >> recipient, you are hereby notified that any viewing, copying, disclosure or >> distribution of this message or its contents may be subject to legal >> restriction or sanction. If you have received this message in error, please >> notify the sender immediately by electronic mail and delete the original >> message and any attachments without retaining any copies. >> _____________________________________________________________________ >> >> >> >> >> >> > > > > > -- -- Gregory Waleed Kavalec --------------------------------------------- When you give food to the poor, they call you a saint. When you ask why the poor have no food, they call you a communist. -- - Archbishop Helder Camara ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~