|
Posted by DickChristoph on 06/26/06 23:18
At some point they added
sp_databases
as a command that could be run. It works in SQL 2000 anyway.
--
-Dick Christoph
"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:rNPng.53612$fb2.23804@newssvr27.news.prodigy.net...
> Try:
>
> SELECT name FROM sysdatabases
>
> I've also seen the INFORMATION_SCHEMA.SCHEMATA view (SQL 2000) used for
> this purpose but that should be avoided. That technique will break in SQL
> 2005 because the vew behavior was changed to align with the ANSI standard.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "ab" <absmienk@hotmail.com> wrote in message
> news:1151316129.417576.287020@i40g2000cwc.googlegroups.com...
>> This shouldn't be too hard but I can't find the right answer: How can I
>> enumerate all databases in my SQL Server (V7)?
>>
>
>
Navigation:
[Reply to this message]
|