Cd \ Dir *.mdf /s
J Regards, Michael B. Smith, MCITP:SA,EMA/MCSE/Exchange MVP My blog: http://TheEssentialExchange.com/blogs/michael I'll be at TEC'2009! http://www.tec2009.com/vegas/index.php From: G.Waleed Kavalec [mailto:kava...@gmail.com] Sent: Tuesday, January 13, 2009 12:08 PM To: NT System Admin Issues Subject: Re: SQL 2005 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 CME 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/> ~