| Listing databases |
[This is preliminary documentation and is subject to change.]
How to list databases created on a server
Use this procedure to query the database server. The result is a list of databases created on this server.
This list will display all databases on the server, i.e. it will also show databases that are NOT built for any TOPICA application. |
Open a command prompt and navigate to the folder containing the command scripts. In this command prompt, enter the command ListDatabases (with no parameters). The command prompt will display:
ListDatabases - list databases
Missing parameter(s) - expected:
Server Username Password
Server:
Servername (use "." or "localhost" for current machine).
Username:
Login.
For trusted connection (= Windows authentication): use "*".
Password:
Password.
For trusted connection (= Windows authentication): use "*".Examples:
ListDatabases MyServer sa sapassw
List databases created on server "MyServer" using SQL Server login "sa" and password "sapassw".
ListDatabases MyServer * *
List databases created on server "MyServer" using Windows authentication.