| title | sqlsrv_server_info | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 01/19/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | connectivity | ||
| ms.reviewer | |||
| ms.technology | connectivity | ||
| ms.topic | conceptual | ||
| apiname |
|
||
| apitype | NA | ||
| helpviewer_keywords |
|
||
| ms.assetid | ef6fe2b7-d267-4379-b948-5626c4684367 | ||
| author | David-Engel | ||
| ms.author | v-daenge |
[!INCLUDEDriver_PHP_Download]
Returns information about the server. A connection must be established before calling this function.
sqlsrv_server_info( resource $conn)
$conn: The connection resource by which the client and server are connected.
An associative array with the following keys:
| Key | Description |
|---|---|
| CurrentDatabase | The database currently being targeted. |
| SQLServerVersion | The version of SQL Server. |
| SQLServerName | The 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);
?>