;-) Actually this is a good HINT at the very least! On Tue, Jan 13, 2009 at 11:25 AM, Michael B. Smith < mich...@theessentialexchange.com> wrote:
> 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 > > *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 > > > > > > > > > > > -- -- 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/> ~