PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → MSSQL
MSSQL
Débuté par Kel, 20 sep. 2019 00:59 - 1 réponse
#1
Posté le 20 septembre 2019 - 00:59
Hi
Is there any functions that will return a list of active mssql servers and if there are is there a function to return a list of databases on the selected server

Thanks
#2
Membre enregistré
2 messages
Posté le 23 septembre 2019 - 16:00
SELECT name FROM master.sys.databases

will get you a list of databases on the server you attach to, if you have privileges for it..
as far as servers go, there is some powershell commands but I don't know about using them.

Andy <<Cowboy>> Stapleton
Wxperts LLC
→ Revenir à WINDEV 2024