Monday, March 12, 2012

Generating a list of databases in SQL2005?

Silly question but... in SQL 2000 it used to be possible to right click on
the "databases" folder in SQL enterprise administrator and export a list of
databases. I can't seem to do the same thing in SQL 2005 Management Studio.
Is there an equivelant way of doing this?
Thanks,
BradSees that feature is missing from the GUI. How about a SQL query instead?
SELECT name FROM sys.databases
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brad Baker" <brad@.nospam.nospam> wrote in message news:uQp%234sj9GHA.3396@.TK2MSFTNGP04.phx.gbl...
> Silly question but... in SQL 2000 it used to be possible to right click on
> the "databases" folder in SQL enterprise administrator and export a list of
> databases. I can't seem to do the same thing in SQL 2005 Management Studio.
> Is there an equivelant way of doing this?
> Thanks,
> Brad
>|||Thanks! That does the trick.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uBFcnEn9GHA.4224@.TK2MSFTNGP02.phx.gbl...
> Sees that feature is missing from the GUI. How about a SQL query instead?
> SELECT name FROM sys.databases
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brad Baker" <brad@.nospam.nospam> wrote in message
> news:uQp%234sj9GHA.3396@.TK2MSFTNGP04.phx.gbl...
>> Silly question but... in SQL 2000 it used to be possible to right click
>> on the "databases" folder in SQL enterprise administrator and export a
>> list of databases. I can't seem to do the same thing in SQL 2005
>> Management Studio. Is there an equivelant way of doing this?
>> Thanks,
>> Brad

No comments:

Post a Comment