sqlsrv_server_info

sqlsrv_server_info

 

DownloadDownload PHP Driver

Returns information about the server. A connection must be established before calling this function.

  
sqlsrv_server_info( resource $conn)  

Parameters

$conn: The connection resource by which the client and server are connected.

An associative array with the following keys:

KeyDescription
CurrentDatabaseThe database currently being targeted.
SQLServerVersionThe version of SQL Server.
SQLServerNameThe name of the server.

The following example writes server information to the console when the example is run from the command line.

<?php  
/* Connect to the local server using Windows Authentication. */  
$serverName = "(local)";  
$conn = sqlsrv_connect( $serverName);  
if( $conn === false )  
{  
     echo "Could not connect.\n";  
     die( print_r( sqlsrv_errors(), true));  
}  
  
$server_info = sqlsrv_server_info( $conn);  
if( $server_info )  
{  
      foreach( $server_info as $key => $value)  
      {  
             echo $key.": ".$value."\n";  
      }  
}  
else  
{  
      echo "Error in retrieving server info.\n";  
      die( print_r( sqlsrv_errors(), true));  
}  
  
/* Free connection resources. */  
sqlsrv_close( $conn);  
?>  

SQLSRV Driver API Reference
About Code Examples in the Documentation

Community Additions

ADD
Show:
© 2016 Microsoft