or in QA

MASTER DATABASE...

sp_helpdb

if you want the datafiles...

use DATABASE
go
sp_helpfile
go

Luís Manuel Martins Ganhão
Novabase, Desenvolvimento à Medida
Serviços de Valor Acrescentado
DBA Oracle Certified Professional
Av. Engº Duarte Pacheco, Torre 1 - 9º
1099-078 Lisboa
Tel: 351213836300
Tlm +351967610858
http://novabase.pt
CONFIDENCIALIDADE: Este e-mail é confidencial e apenas pode ser lido,
copiado ou utilizado pelo destinatário. Se o recebeu por engano, por favor
contacte o remetente através de e-mail ou pelo telefone + 351 21 383 63 00.
Agradecemos ainda que apague este e-mail e não divulgue o respectivo
conteúdo.
CONFIDENTIALITY: This e-mail is confidential and may be privileged. It may
be read, copied and used only by the intended recipient. If you have
received it in error, please contact the sender immediately by return e-mail
or by phoning + 351 21 383 63 00. Then please delete this e-mail and do not
disclose its contents to any person.


-----Original Message-----
From: Farnsworth, Dave [mailto:[Email Address Removed] terça-feira, 16 de Julho de 2002 12:32
To: LazyDBA.com Discussion
Subject: RE: OT SQL SERVER


In QA do this

exec sp_databases

Dave

-----Original Message-----
From: Baki [mailto:[Email Address Removed] Tuesday, July 16, 2002 1:49 AM
To: LazyDBA.com Discussion
Subject: OT SQL SERVER


In SQL SERVER how can i list all database
with a query?


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
MS Sql Server LazyDBA home page