GET_NO_AVAILABLE_SQLSERVERS¶

Applies to: SQLFlex

This command is used to get the number of available MSSQL servers detected in the network. When used with GET_SQLSERVER_NAME, all the available server names can be easily retrieved.

Syntax

GET_NO_AVAILABLE_SQLSERVERS to {variable}

Parameter	Description
variable	Variable to hold number of servers

Example

GET_NO_AVAILABLE_SQLSERVERS to iServers

While (i <= iServers)
    GET_SQLSERVER_NAME i to sServer
    Showln sServer
    Increment i
Loop

GET_SQLSERVER_NAME