You can also try running the following on master database select * from sys.sysaltfiles
this will list both transaction log and database file locations. --Tigran On Mon, Jan 12, 2009 at 4:51 AM, Doige, Clayton <[email protected]>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:[email protected] > > 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. > _____________________________________________________________________ > > > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
