Posted by Dan Guzman on 06/26/06 11:45

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)?
>

[Back to original message]