OSQL

Is there a command in OSQL that will list databses running on MSDE?
Thanks
Tunji
www.geniant.com
Once you have connected to an instance of MSDE 2000 you can use either of
the following queries to get a list of all the databases created in that
instance:
SELECT CATALOG_NAME
FROM INFORMATION_SCHEMA.SCHEMATA;
GO
SELECT name
FROM dbo.sysdatabases;
GO
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
|||Thanks Alan.
"Alan Brewer [MSFT]" <alanbr@.microsoft.com> wrote in message
news:eMTyWInIEHA.3356@.TK2MSFTNGP11.phx.gbl...
> Once you have connected to an instance of MSDE 2000 you can use either of
> the following queries to get a list of all the databases created in that
> instance:
> SELECT CATALOG_NAME
> FROM INFORMATION_SCHEMA.SCHEMATA;
> GO
> SELECT name
> FROM dbo.sysdatabases;
> GO
> --
> Alan Brewer [MSFT]
> Lead Programming Writer
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
>