|
Posted by ab on 06/26/06 13:36
Thanks Dan, that helped.
Dan Guzman schreef:
> 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]
|